Re: SQL Database performance
On Thu, Nov 19, 1998 at 04:58:00PM +0000, 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 databases: one of roughly ten thousand
> records a few k in size, the other 100,000 rather smaller records. It
> might well be feasible to use something like gdbm for the latter one.
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 noticed. We're currently
deploying Oracle on a Debian server...
Oracle is bloatware even by Microsoft standards. I can't comment on
speed yet.
Good luck,
Jeff
Reply to: