Re: [sqlite] Increase speed of database on cdrom

2005-05-31 Thread Uwe Steinmann
Christian, Ulrik, Thanks for the very informative answer. I'll try VACUUM first. Uwe On Tue, May 31, 2005 at 12:37:44PM +0100, Christian Smith wrote: > On Tue, 31 May 2005, Uwe Steinmann wrote: > > >Hi, > > > >I've created a sqlite database with about 140 MB filesize which is > >going to be sh

Re: [sqlite] Increase speed of database on cdrom

2005-05-31 Thread Christian Smith
On Tue, 31 May 2005, 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

Re: [sqlite] Increase speed of database on cdrom

2005-05-30 Thread Ulrik Petersen
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

2005-05-30 Thread Uwe Steinmann
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