List:General Discussion« Previous MessageNext Message »
From:Ed Carp Date:October 6 2002 9:08pm
Subject:RE: Performance Question.
View as plain text  
> 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
Thread
Performance Question.Robert H.R. Restad6 Oct
  • RE: Performance Question.Peter Lovatt7 Oct
    • RE: Performance Question.Ed Carp7 Oct
      • RE: Performance Question.Peter Lovatt7 Oct
        • RES: Performance Question.Robert H.R. Restad7 Oct
          • RE: Performance Question.Ed Carp7 Oct
          • RE: Performance Question.Ed Carp7 Oct
    • RES: Performance Question.Robert H.R. Restad7 Oct
      • Re: RES: Performance Question.Niclas Hedhman7 Oct
        • RE: RES: Performance Question.Ed Carp7 Oct