RE: Performance Question.

[Ed Carp]

> 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