I don't see the same issue here under OS9. Performance is roughly the same as under OSX in my tests under OS9 or Classic. I have however compiled both the Carbon and Classic versions using CodeWarrior, but in theory it should not make a difference (not sure how you have created your OS9 library.) I am not using SQLite standalone as well, but as part of another program, embedded. Just tried a SELECT with LIKE on a 40MB database, and it completed OK in roughly 1 sec, looks like the same time as the OSX build. Maybe you are running out of real memory under OS9? The system may be using VM on disk, which can be very slow under OS8 and 9. Try to increase the initial memory allocation for your SQLite binary or program, or disable VM, and see if it makes a difference.
Regards, Mauricio Piacentini Tabuleiro ----- Original Message ----- Subject: performance on Mac OS 9 -- I've been working on a Mac OS X version of SQLite and things are very quick. But now I'm trying similar code on OS 9 <snip> I can hear the disk churning away and a query that takes 1-2 seconds on OS X takes 50 seconds on OS 9. ... --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
