At 13:47 15/10/2008, you wrote: >Hi there, > >i am using a 120MB database in an embedded project (a DVD-ROM project) >and was wondering what I can do to speed up its reading using diverse >PRAGMA statements. >The database is locked, meaning that no data is being inserted or >deleted from it. I am solely after speeding up its reading performance. > >Indices have been set, would augmenting the cache size for Sqlite do >something?
How many memory has your embedded project? You can create a new in-memory database and copy there your database data. >Grateful for any info, > >-- >Christophe Leske _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users