> I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run > queries on datasets of 220,000 > > SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time > than I can count (0.1 sec at a guess) > > The insert/update bit is the bit which will dictate the speed - how many > records need updating?
Don't forget the considerable overhead of PHP itself. sql, query --------------------------------------------------------------------- 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
