Re: [sqlite] Performance tuning, and other (silly?) SQLitequestions.

> Ken <[EMAIL PROTECTED]> wrote: > > Can you do a test load to a memory database. What is the performance > (row/sec) of your data using an in memory database? I tried a RAMDisk on Windows. I haven't tried at home on Linux. I'm not sure if I tried the C API to RAMDisk database combination,

Re: [sqlite] Performance tuning, and other (silly?) SQLitequestions.

Or you will need to get a faster disk drive! And more of them. Consider a raid 0 system using striping. High speed fiber connects will also be helpful. Can you do a test load to a memory database. What is the performance (row/sec) of your data using an in memory database? Is

Re: [sqlite] Performance tuning, and other (silly?) SQLitequestions.

James Steward <[EMAIL PROTECTED]> wrote: > > Michael Ruck <[EMAIL PROTECTED]> wrote: > > > > I know that a natural join exists, but it is not automatic as > > it seems to be in MySQL. > > Thanks , and thanks to all who replied to my questions. > > I've been testing SQLite's speed, for