List:General Discussion« Previous MessageNext Message »
From:Daniel Koch Date:April 16 1999 11:21pm
Subject:Re: mysql performance way down with php
View as plain text  

Shalendra Majmundar wrote:
> It is really a php question, but I thought this active group may have an
> answer for me :)
> A search yeilding 2500 records from one table in mysql takes 0.22 sec as
> shown by the
> time command. Same query from php took 1 minute 20 secs. I even tried
> compiling php for stand-alone parsing, and from php shell (command line)
> it erred out with "Exceeded 30 seconds time limit".
> What am I missing?? Please post me on any tip to boost performance.
> Versions:
>         O/S RedHat 2.0.36
>         PHP 3.0.5
>         MySql: 3.22.20a
> Thanks in advance!
> Sam

I think an example of the query and the PHP script would be in order!

Dan Koch
American City Business Journals
Case Sensitive SearchingKevin P. O'Brien16 Apr
  • Log fileChai-Hup Chen16 Apr
    • mysql performance way down with phpShalendra Majmundar17 Apr
    • Re: mysql performance way down with phpDaniel Koch17 Apr
      • Re: mysql performance way down with php(Graeme B. Davis)17 Apr
    • Log fileMichael Widenius17 Apr
Re: Case Sensitive SearchingFred Lindberg16 Apr