Re: [cobalt-users] MySQL limits- OFF TOPIC -

[johan@xxxxxxxxxx]

Jorge,

Sorry about the lengthly reply - but it will hopefully 
point you in the right direction ...

> When is it a good time to consider migrating to a more efficient 
> db - Oracle maybe?  What db's must be considered for the long 
> term? - pref. working on linux

I would consider using PostgreSQL for the short to medium term for a 
package tracking system.  Oracle might be your best in the long run.
Why? Read on ...

Take a look at http://openacs.org/ to get a feel for what Postgres 
can handle.  OpenACS is a Postgres port of the ARSDigita Community 
System, which uses Oracle (http://www.arsdigita.com/).

I'm sure you've heard about Philip Greenspun - he used to be quite 
outspoken about the use of Oracle as opposed to mySQl and other open 
source databases. This article by Philip explains the so-called ACID 
(Atomicity,Consistency,  Isolation,Durability) test:
 http://www.arsdigita.com/books/panda/databases-choosing.html

Finally, OpenAcs has a great forum - this was posted in August 
2000 (the link to the original ApacheToday article points to a 
dead end):

>>
PostgreSQL Outperforms MySQL, Interbase and two other commercial DBs

MySQL didn't even make it and Interbase had a problem because of the 
lack of a stable ODBC driver.

"In the TPC-C tests, Postgres performed neck and neck with the two 
leading proprietary databases." (product names not revealed due to 
license agreement issues.) 

The performance tests were made using PG's ODBC driver AFAIK... I 
wonder what we'd get using native drivers. Go PostgreSQL, and 
kudos to the PG developers: 

"In the AS3AP tests, PostgreSQL 7.0 significantly outperformed 
both the leading commercial and open source applications in
speed and scalability. In the tested configuration, Postgres 
peaked at 1127.8 transactions per second with five users, and 
still processed at a steady rate of 1070.4 with 100 users.  

The proprietary leader also performed consistently, with a high 
of 314.15 transactions per second with eight users, which fell
slightly to 288.37 transactions per second with 100 users. The 
other leading proprietary database also demonstrated consistency, 
running at 200.21 transactions per second with six users and 197.4 
with 100." 

"The other databases tested against the AS3AP benchmarks, open 
source competitors MySQL 3.22 and Interbase 6.0, demonstrated some 
speed with a low number of users but a distinct lack of scalability. 
MySQL reached a peak of 803.48 with two users, but its performance
fell precipitously under the stress of additional users to a rate 
of 117.87 transactions per second with 100 users. Similarly, Interbase
reached 424 transactions per second with four users, but its
performance declined steadily with additional users, dropping off to
146.86 transactions per second with 100 users."
>>

Hope this will be useful,

Johan Pretorius
http://host24.com





---------------------------------------------
This message was sent using M-Web Airmail.
http://airmail.mweb.co.za/