List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:April 17 1999 4:07am
Subject:Re: mysql performance way down with php
View as plain text  
Take a look at Roxen ;)  http://www.roxen.com

you can do stuff like:

<sqloutput query="select name, date from people order by name;">
#name# - #date#
</sqloutput>

it makes dynamic sites so easy to make...and the code (IMHO) is prettier than PHP3

-Graeme

Daniel Koch said:
> 
> 
> 
> 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
> Webmaster
> American City Business Journals
> http://www.amcity.com/
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread1967@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 
> 

Thread
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