search

mar-file-system / GUFI

Grand Unified File-Index
Other
46 stars 23 forks source link

Cache Queries #95

Closed calccrypto closed 2 years ago

calccrypto commented 2 years ago

This was what #89 was supposed to be, but there were no performance improvements. Leaving this here in case we want to go back to it again.

calccrypto commented 11 months ago

This won't work because prepared statements are recompiled after a schema change, such as when an index db.db is attached.

https://github.com/sqlite/sqlite/blob/3e4195c60db744c69bb24e71236631a80f2ef547/src/prepare.c#L876-L912