Benchmark with Oracle SQL Server

[Rodney Whiddon]

Has anyone out there run a side-by-side performance analysis between
Pervasive 7 and Oracle 7/8 or MS SQL 6.5/7? If so, can you share the
results and test platform description. Are there any relevant comparison
articles you have seen in DBMS, etc..? We are running about 70 sets of
Btrieve database files in a distributed network. This is becoming
difficult to manage and we are looking for options.

Thanks,

Rodney Whiddon
VP Development
214-640-4161
NTC

[Luis Antonio Márquez García]

Sql Server 6.5 is a good database if you have no problem to support your
clients 24 hours a day. It's slow, sometimes AutoInc fields are not updated,
etc.. And Microsoft support, they are ...

Now we use Pervasive 2000.

--
Luis Antonio Márquez García
la...@olinet.es
OLINET, S.L. (Spain)

-----Mensaje original-----
De: Rodney Whiddon <rodney....@ntcworld.com>
Para: comp.databa...@list.deja.com
<comp.databa...@list.deja.com>
Fecha: jueves, 07 de octubre de 1999 4:40
Asunto: Benchmark with Oracle SQL Server

> Message from the Deja.com forum:
> comp.databases.btrieve
> Your subscription is set to individual email delivery

> _____________________________________________________________
> Deja.com: Before you buy.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.btrieve
> * Read this thread at
> http://www.deja.com/thread/%3C7tav2a%248j5%241%40illusion.connect.net%3E

Sent via Deja.com http://www.deja.com/
Before you buy.

[Bernhard Mandl]

Rodney,

I did some test with PSQL 7 and Oracle 8 and came to these results:

1.) If your programs use the Btrieve API and are programmed well then you
will probably have BIG program changes and a BIG performance decrease in
interactive programs that rely on quick response when you switch to any SQL
based backend.

2.) If you already use the Pervasive SQL interface it depends very much on
what you are doing. Complex queries may be much faster on Oracle because is
has a good optimizer that you can further tune with 'hints' (PSQL tends to
take forever on some queries and there is nothing like "explain plan" that
helps to optimize). Simple SQL statements my be processed faster by PSQL
than by Oracle.

In other words: you will have to run your own tests. Don't trust anyone's
performance comparision if they are not run on your data.

Regards,
Bernhard

Rodney Whiddon <rodney....@ntcworld.com> wrote in message
news:7tav2a$8j5$1...@illusion.connect.net...