Re: [phpesp-general] phpESP is running really slow...

[James E. F. <jf...@ac...>]

400 questions huh? I feel really sorry for the people who
have to fill out that survey -- I get impatient after about
10.

Well, probably the slowness is coming from the SQL queries.
Is the mysql server the same box as the web server? Here
are some tools you can use to check out performance on your
box:
  iostat -w1     (show I/O stats)
  vmstat -w1     (show VM stats)
  netstat -w1    (show net stats)
Try running each of those and see if anything spikes
unreasonably high when someone is using phpESP. That should
give you a place to start. Once you pin it down to disk or
memory or cpu let me know which it is and we'll go from
there. (I am guessing all those utils exist on OS X since
they do on FreeBSD, consult your local man pages for
details.)

-James

On 13 Apr 2002, Unix Newbie wrote:

>
>
>  Hello again,
>
>
>   I was hoping I could pick your brains yet again. I have a question
> regarding this softwares performance. My users have set up these
> wonderful surveys with about 400 questions each, complete with breaks,
> etc. Making any edits or pretty much doing anything with survey takes
> about 2-3 minutes. I'm getting a lot of complaints about this and I'm
> not sure what to do about it.
>
>   My system is a Mac OS 10.1.3 box, a 733 G4 with 700megs of RAM and an
> 7200rpm ATA drive (I know, not the best). I have order 1.5 gigs of RAM
> to put in there, and I am defraging the drive tonight. I am really at a
> loss though to say if that is problem because CPU usages is always
> really low. Any ideas, where to turn too? Do I maybe have something
> configured wrong?
>
>
>    Thanks soo much again everyone! As aways, docs, urls, anything helps!
>
> Sincerly,
>   Terry.