search

randomouscrap98 / contentapi

A generic content system to make some kinda standard websites
GNU General Public License v3.0
8 stars 2 forks source link

Potential SQLite memory over usage #137

Closed randomouscrap98 closed 2 years ago

randomouscrap98 commented 2 years ago

I may be abusing my SQLite connections. People suggest callingpragma shrink_memory on long running connections. Also, you could set up a cronjob (already have one) to VACUUM the database, but that's mostly a space and fragmentation thing

randomouscrap98 commented 2 years ago

I don't think this is necessary anymore. The memory usage appears to have shrunken significantly with recent changes, and each individual websocket connection no longer seems to take up any additional memory (or at least, I can't see it)