Hi. I'm doing a search of a 2-million-record book table. The table is
searched very heavily, and while most queries are finished in a second or
two, some take a disproportionately long time - any time a very common word
such as 'john', which matches upwards of 80,000 records, is included in the
I have just upgraded my test server to MySQL 4.0.0 from MySQL 3.23.44
There is a 2Gb table with 2286869 records which I can query fine on MySQL
3.23.44, but when I change over to MySQL 4 if I try and INSERT or REPLACE
any records it keeps saying 'Duplicate entry' and when I do an UPDATE, it
==
Laurence Aronberg
Team Leader
Serious Global Ltd
Phone: +44 (0)20 7467 1430
Fax: +44 (0)20 7467 1440
Email: mailto:[EMAIL PROTECTED]
Web: http://www.seriousglobal.com
The information