Re: SQL Database performance

1998-11-20 Thread Carey Evans
Jeff Noxon <[EMAIL PROTECTED]> writes: > Postgresql runs like greased lightning. In some tests involving > 0.5 million records of a few K in size, it blew away MS SQL Server. > I think it was version 6. Postgresql runs well, although it does have > some limitations. ODBC was the main weakness I

Re: SQL Database performance

1998-11-19 Thread Kevin Cheek
See http://www.tcx.se/benchmark.html for some interesting benchmarks comparing several common db systems including oracle, ms-sql, pgsql, and others. For a pretty comprehensive comparison of database system limitations and capabilities, see http://www.tcx.se/crash-me-choose.htmy I use MySQL for

Re: SQL Database performance

1998-11-19 Thread Jeff Noxon
On Thu, Nov 19, 1998 at 04:58:00PM +, Martin Oldfield wrote: > Does anyone have a feel for the relative performance of the various > SQL databases in Debian ? I'd also be interested to know how these > compare to something like Oracle (under either NT or Linux). > > I'm looking to manage two d

SQL Database performance

1998-11-19 Thread Martin Oldfield
Does anyone have a feel for the relative performance of the various SQL databases in Debian ? I'd also be interested to know how these compare to something like Oracle (under either NT or Linux). I'm looking to manage two databases: one of roughly ten thousand records a few k in size, the other 1