Don't use Mysql. if you ever have had to deal with it in a production
environment that works it over, you will know that as it reaches it's
limits, it starts a death spiral that is very difficult to recover from.
For our software on a dual P3 866 with a gig of ram, the limit was
around 1.5
My example of heavy load where mysql could not even begin to handle the
situation was a project with real time stock market data streamed in as
bids and offers and trades happened, statistics computed from that in real
time, database kept in sync live, and charts and graphs plotted in real
was that mysql 3.23.x or 4.0.x ?
michael
I did most of my mysql work some time ago with 3.x. I have, however,
installed mysql 4.0.12 since I'm working on a CASE tool which needs to
support both mysql and postgresql. I'll be the first to admit that
mysql has probably improved (a lot?) since