Hi !
I've got a php script that does about 100 UPDATE queries against a database. The script looks something like this:
mysql_query("update table1 set a1=somevalue1 where id='$id'");
...
...
mysql_query("update table1 set a100=somevalue100 where id='$id'");
i do not free any memory in the script(is this possible?)
but when i run this on web server mysql server crashes. The admins say 'that the script creates too many processes', or something like that and claim that it's my fault to crash their server.
Is there anything i can do in my script to not to crash mysql server or does the server crash due to faulty configuration?
Is there any max nr queries that i can run in php script?
thanks to everyone who will respond
Elmo
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
I've got a php script that does about 100 UPDATE queries against a database. The script looks something like this:
mysql_query("update table1 set a1=somevalue1 where id='$id'");
...
...
mysql_query("update table1 set a100=somevalue100 where id='$id'");
i do not free any memory in the script(is this possible?)
but when i run this on web server mysql server crashes. The admins say 'that the script creates too many processes', or something like that and claim that it's my fault to crash their server.
Is there anything i can do in my script to not to crash mysql server or does the server crash due to faulty configuration?
Is there any max nr queries that i can run in php script?
thanks to everyone who will respond
Elmo
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->