[sqlite] size of the cache

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

[sqlite] sqlite with Visual Basic

If you search a wrapper for VB6, I did one with a VB6 COM DLL which permit to use classes which look like the DAO classes for access (Database and Recordset). I have made little change to the C Dll to avoid create a SAFEARRAY and need less memory for big select statements. If you want it, I can

RE: [sqlite] sqlite with Visual Basic

If you search a wrapper for VB6, I did one with a VB6 COM DLL which permit to use classes which look like the DAO classes for access (Database and Recordset). I have made little change to the C Dll to avoid create a SAFEARRAY and need less memory for big select statements. If you want it, I can

[sqlite] Vacuum and UseJournal

I remark the vacuum Op do nothing if I turn off the useJournal. Is it normal ? Thanks in advance. Jérome

[sqlite] Attach database

While trying to attach a readonly database to another one, I get the message « root page number less than 2 “, It reproduces itself almost each time. I precise the database which has to be attached is a readonly one. Do you have some idea ? Thanks a lot, and excuse me for my english.