Massive Speed difference between Mac/PC with SQLite

[viktoras didziulis]

Hi Dave,

try building your database in :memory:  mode. Then dump it to hard disk 
when ready. I do this routinely in an Rev/SQLite program that deals with 
100 000 records distributed over 25 tables with about and 127 fields and 
it takes less then 2 seconds to copy the entire database to RAM and no 
query returning thousands of records from the database takes longer then 
7 secs on a  modest 1,4 GHz Windows XP system with 256 Mb RAM. Well, 
queries had to be manually optimised, otherwise "traditional" joins of a 
few tables took ~10 min. to execute returning the same result set.

One more alternative hint for sqlite (this won't work with in-RAM 
databases launched from within Rev, but will for any hard-disk based db) 
is to NOT use SQL to populate the entire database with large amounts of 
data. Use shell to sqlite3 executable to .import FILE TABLE. This works 
much, much, much faster.

Viktoras

Dave wrote:
> Hi,
>
> I have an application that works on Mac and PC. There is a process 
> that read an XML file, re-arranges the data and writes a record to an 
> SQLite database. On the Mac, to build a 10,000 Tracks database takes 
> around 90 seconds, how ever on the PC the same code (both in the 
> Standalone and the IDE) runs, much, much, slower. The same 10,000 
> records takes over 10 minutes!
>
> Does anyone have an idea why this should be?
>
> All the Best
> Dave
>  
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>