Linux RH 6.2 on intel 333Mhz, 128Mb, PHP4.0.4, mySql 3.22.28 gamma-log
Here is the problem: I've just started using objects in PHP, and I LIKE them. But when I rewrote a basic search page to use objects, I get big system slowdowns, very long response times via http.
is there a known bug that would cause this problem? Can anyone suggest anything?
For the detail-oriented here's a typical sequence;
The search is part of a mysql-based catalogue. If I browse the catalogue via the web interface, everything is fine. (None of the browsing scripts involved use objects). Now, I type a search in the search field (which uses the same databases). If I type in a search for things I know aren't going to be found, the response is quite bit slower, but the response comes back. If I search for something that I know will be found, however, the response never comes back, and in fact if I do this on the server itself using Netscape, Netscape freezes up, and I can't get a response (using Gnome). However, on another machine, I can typically still browse the catalogue, and responses are fine, indicating that apache, mysql and php are all still functioning.
I'd be inclined to say the machine is out of RAM, but free or cat /proc/meminfo don't seem to indicate this. If anyone is interested, I could post the output from free.
In short, when I use the object-based scripts things come to a crashing halt. Mysql doesn't show database problems using myisamchk, and there is lots of disc space etc.
I'd love to be using the object oriented approach - has anyone got any words of help or advice?
