[sqlite] performance on Mac OS 9

[Will Leshner]

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 on basically the same 
hardware and while indexed searches are still very fast, if I do a 
SELECT with LIKE, performance is really bad. I can hear the disk 
churning away and a query that takes 1-2 seconds on OS X takes 50 
seconds on OS 9. I'm wondering if anybody has any thoughts on what 
could be causing such a difference in performance. Could it have to do 
with the superior virtual memory on OS X? Or is there some file system 
difference perhaps?

Thanks for any info.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]