On Nov 15, 2003, at 8:17 PM, Will Leshner wrote:
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?
Sorry to answer my own question, but it turns out the problem on Mac OS 9 is a really poor file manager. The OS 9 code in os.c uses FSRead to read from files and as best I can tell the reads just aren't buffered hardly at all. So I implemented some simple buffering in os.c and managed about an 8x increase in speed. My guess is that few people care about Mac OS 9, but this might be an issue on other OSs with poor file managers.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
