PDA

Click to See Complete Forum and Search --> : Databases

goon12
11-27-2002, 12:45 AM
For a fairly busy site, what would you say is a better choice for a database? MySQL or PostgreSQL?

It will be responsible for order, items, customers, shipping, accounting etc ( the usual retail site ) on a site that gets 200-300 hits perday.


PS I dont want to start a flame war.
BoomerADF
11-27-2002, 02:14 AM
mySQL is what I would go with. 300hits a day is not to bad at all.
theN
11-27-2002, 09:28 AM
Originally posted by goon12
For a fairly busy site, what would you say is a better choice for a database? MySQL or PostgreSQL?

It will be responsible for order, items, customers, shipping, accounting etc ( the usual retail site ) on a site that gets 200-300 hits perday.

PS I dont want to start a flame war.

depending on the hardware, you could consider running MySQL with InnoDB on. You will transaction support with logical rollbacks. AFAIK PostgreSQL may not have transaction support yet.

MySQL (http://www.mysql.com) has the relevant details.

Regards
theN