PHP / MySQL script hangs after ~2500 queries

preptaxia

New Member
I have a script that loads between ~5000-8000 objects, performs some logic on them and then attempts to insert/update the MySQL table. After about 2500 queries, the database stops executing the queries and the script just hangs with no error thrown. I need advice on what you would do in this situation. The server is a Windows box if that makes a difference. I am using mysql_connect in PHP5. I have placed mysql_error statements with exit commands after all of the queries and they never fire. I have also set\[code\]set_time_limit(0);ini_set("memory_limit", "256M");error_reporting(E_ALL | E_STRICT);\[/code\]in an attempt to throw more errors. Nothing at all happens, no errors and it does not finish executing. The row that it stops at is also random, nothing unique about it as it is always a different row that is updated before it stops. What type of techniques would you use to profile this bug?
 
Back
Top