Hi, I want to optimize requests on a big database which works with sqlite 2.8.14. The first time I make a sql request, is spends 4 minutes before returning a result, but the second time, it take only 2 seconds. I think it’s the use of the cache which permits such performances. S
How can I modify Sqlite source code to keep the integrality of a big database in the cache? It will permit to respond rapidly to all the differents queries I will be able to submit. Thanks in advance Jerome.
