Re: [sqlite] Increase speed of database on cdrom

Hi Uwe, Uwe Steinmann wrote: Hi, I've created a sqlite database with about 140 MB filesize which is going to be shipped on cdrom. The database is read by a java application. I made some rought speed comparision between the database being on cdrom and on hard disk. On startup a tree is filled w

[sqlite] Increase speed of database on cdrom

Hi, I've created a sqlite database with about 140 MB filesize which is going to be shipped on cdrom. The database is read by a java application. I made some rought speed comparision between the database being on cdrom and on hard disk. On startup a tree is filled with data from two tables. When re

Re: [sqlite] completion of sqlite3_exec

Eno Thereska wrote: Is there a way to know if a row returned through the callback to sqlite3_exec is the "last" row that will be sent (i.e. the query has finished completely)? I ask because I have per-query data structures that I need to free once I know a query has completed. Eno, Your ca

[sqlite] completion of sqlite3_exec

Hi, Is there a way to know if a row returned through the callback to sqlite3_exec is the "last" row that will be sent (i.e. the query has finished completely)? I ask because I have per-query data structures that I need to free once I know a query has completed. I was expecting the callback f

Re: [sqlite] Performace degradation over time

John, I've tried the following test program (in pseudo code): for(i = 0; i < 10; i++){ insert row with new primary key; rowid[i] = last_row_id(); } for(;;){ for(i = 0; i < 10; i++){ r = random(10); delete from table where id = rowid[r]; insert row; rowid[r] = last