Giving PHP an Ooomph

[Anon]

Hey everyone, I know you can set a maximum memory limit in php.ini to prevent scripts from eating up server resources, but is there a way to set the limit higher for a particular script, or maybe even on the fly (like set_time_limit)? The reason I ask is because I have a segment of code that, deep within a script of SQL queries and sorting, takes .76 seconds to run the while ($data=mysql_fetch_array($result)) { // make array }. Outside of that script it takes only .04 seconds --- same code exactly, same queries. I'm assuming the script is taking up more memory than the test script that takes only .04 seconds. Is there a way to prioritize this script so it can take up all the memory it wants and have as fast execution as possible? It's a search engine code for our site and I'm trying to speed it up as much as possible. MySQL is running at great speeds, but PHP is slowing us down.

Thanks,

Mike

[Anon]

This issue is really confusing me. I have this big script which does all kinds of stuff and queries. In one segment it does a query and gets a result (time: 0.03 seconds). It creates an array via while ($data=mysql_fetch_array($result))) { $myarray[$X]=$data[0]; // etc. } .... and it takes 0.72 seconds to do this for 255 rows. When I run the exact same ~ 20 lines of code in a script by itself, it takes 0.04 seconds. Why? How can I get it to run as well as it does in that segment? What is the problem here?

Mike

[cheald]

If that code is executing so quickly, it's probably not that chunk of code that's slowing it down - check the rest of the script for bottlenecks. One way is you could add the current microtime to an array every X lines of code, and compare those values to find your slowdown.