Out of memory errors?

[chrisspen]

I'm trying to query over a sequences of multiple Sqlite3 databases, and after a few dozen, I start getting the error:

RuntimeError: abort(RangeError: WebAssembly.instantiate(): Out of memory: wasm memory). Build with -s ASSERTIONS=1 for more info.

I'm using a version of your load() that accepts an argument for the sqlite3 path.

Is there anything I can do to fix this error? I'm not purposefully persisting any objects, as far as I know, and I only need to access one database at a time. Is there something I need to do to explicitly free up memory used by a previous createDbWorker() instance? Is there like a destroyDbWorker()?

[phiresky]

There might be a memory leak somewhere in the sql.js-httpvfs code (e.g. not freeing statements). I only "optimized" the code for a single DbWorker created once. I probably can't really help you there, you might have to play around to figure out what causes the memory issue. Loading fairly large databases worked ok for me as well.

[reyemtm]

I ran into this issue and created 4 workers and randomly switch between them, pretty much solved it for now

[chrisspen]

@reyemtm That's essentially what I'm doing. I'm calling multiple awaits, to launch multiple createDbWorker. It's enough to load the data, but if the user enters a new query, I need to first refresh the page to release memory. Otherwise, the browser runs into out-of-memory errors and crashes.

[jlarmstrongiv]

Was this issue mitigated by recent commits like 1d6819c ?