MySQL is nice, and fast but I don't think it's at all suitable for what
you have in mind. There was a recent comparison of PostgreSQL vs MySQL
and PostgreSQL beat it in terms of speed. This was a CVS version though,
and they used the last beta version of MySQL at the time.
(http://www.phpbuilder.com/) As with all benchmarks it's better to do it
yourself with your own data an application.
I'd agree with John below, give PostgreSQL a serious look..
"John P . Looney" wrote:
>> On Mon, Dec 18, 2000 at 03:29:57AM -0800, Michael Turley mentioned:
> > Has anybody on the list experience of implementing a
> > high volume ecommerce application on Linux and would
> > you like to share your opinion on relevant databases?
> > My experience is limited to Oracle on a commercial
> > Unix and mysql on Linux. The lads here think that SQL
> > server on NT/2000 might be a worthwhile option, if
> > only in a commercial sense.
>> Ask the developers in online.ie - they went with Oracle, and really
> regret it. It's horrid. PostgreSQL seems to be the best free one around.
> I'd be surprised if it wasn't better all round than SQLServer.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!