Yes I know the Berkeley DB or gdbm solutions out there. However, I need multicolumns and I need more sophiscated feature like ORDER BY and GROUP BY.
-Arthur -----Original Message----- From: Steve Dekorte [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 10:38 PM To: Arthur C. Hsu Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] In-memory DB performance tuning On Nov 17, 2003, at 9:55 PM, Arthur C. Hsu wrote: > Any clues that I can further squeeze the performance? Or the > limitation is by design? I just can't realize why the first 6000 rows > are amazing fast but later the speed drops down so dramatically. Hi Arthur, If you really need performance and can model your data as key/value pairs, then you might consider something like SleepyCat. If I remember correctly, it can read/write around 50K rows per second. -- Steve --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]