Ive written a series of local scripts and they all execute with input -> process -> output all working correctly. the script iterates through a list of objects and performs quite a few different queries on each object before moving onto the next.
it seems that when there are a large amount of objects the script seems to get down to the same point and then just freeze and timeout with an error saying query failed.
an example is:
Warning: mssql_query(): Query failed in /XXXX.php on line 201
Changed database context to 'XXX'.
the sql server is an 8 core zeon with 32gb ram and the system im running on is a 4core xeon with 4gb ram. resource useage is very low, ive also tried the php ini settings by:
increasing the memory to 512MB
increasing the timeouts and code execution.
what can i do to solve this problem? any help would be gratly appretaited! :)