I know this isn't really on topic but I thought some people may find this interesting. The below stats were taken from a non-production server which I dump to from my production server as a kind of backup method using MysqlFront. I might add that today I did several multi-table joins on the world database (+7mil population, languages, surface area of largest city per continent etc...) and still received decent result set times in the order of 0.06 to 0.5 seconds. The server is a lightning fast Pentium Pro 90 with 32 MB EDO RAM and RedHat 7.0. So anyone who still says that the MySQL database can't cut the mustard, obviously hasn't tried.
Mysql 3.23.43 Up 212 days, Processed 199,654 queries (average = 0.01/sec) Processed 2 slow queries (woops ;-) don't you hate leaving out the where statement on joins) Neil Silvester Webmaster Heat and Control Ph: +61 7 3877 6429 [EMAIL PROTECTED] http://www.heatandcontrol.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
