sqlite-wasm-http icon indicating copy to clipboard operation
sqlite-wasm-http copied to clipboard

Not using cache / fetching on every query

Open koenbok opened this issue 2 years ago • 2 comments

Thanks for this really cool project, I'm having a lot of fun playing around with it.

I might be misunderstanding something completely, but from the readme I assumed that once pages were downloaded, they'd be stored in a (shared) cache, allowing fast access afterwards.

So I would expect that if you once would fetch the full data set select * from data and after that just order it select * from data order by id, the second query wouldn't result in any (significant) new data fetching.

But in my simple tests almost every query resulted in lots of data fetching. Why is that the case?

koenbok avatar May 20 '23 23:05 koenbok

Do you use a pool or a single connection and do you have COOP/COEP enabled?

mmomtchev avatar May 21 '23 11:05 mmomtchev

I use a pool (which I keep open between requests) and I have the headers enables. I'll try and make a repro.

koenbok avatar May 21 '23 18:05 koenbok