Re: JDBC / Oracle / MS SQL Server performance anomalies

From: Paul Thomas <paul_at_tmsl.demon.co.uk>
Date: Sat, 25 Jan 2003 00:03:48 +0000
Message-ID: <pan.2003.01.24.23.57.15.822248.8736@tmsl.demon.co.uk>

On Fri, 24 Jan 2003 13:30:32 +0000, AV wrote:

> It is known that Oracle is not "fastest" database, but "fast and
> reliable". According to tpc benchmark results MSSQL is ahead of Oracle
> in low size tests. Also driver can be not optimized for speed but for
> readability.

Something else which th OP might want to consider is that he might not necessarily be running on the fastest platform available. Surely, if speed is an issue then a mainframe running say Oracle or DB/2 might just have the edge over a Windows PC?

At the end of the day, a multi-platform product like Oracle probably can't incorporate many platform-specific speed tweeks. But its certainly a lot more scalable.

-- 
Paul Thomas
Thomas Micro Systems Limited
http://www.tmsl.demon.co.uk

Received on Fri Jan 24 2003 - 18:03:48 CST