[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 modif

[sqlite] in memory databases

I use Sqlite with file databases and I’m wondering if it is possible to load the totality of this db in memory to perform requests. I saw I can specify :memory: for the filename but by this way, I can’t laod my file database in memory. So the question is very simple How can I load the totality

[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 ma

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 ma

[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] Memory leak with PSVBUTLS32

Hi, I use the psvbutls32 dll from windows to access SQLite with Visual Basic. Using PSVBUTLS_ExecuteDB with a select statement, I remark a memory leak. Each time I use it, the memory used by my application increase a lot. Is it a known bug, or a bad use of the API Thanks a lot

[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.