Need guidance Using mysql_query() in loops, and usleep() function

[Rohan Shenoy]

Hi guyz,

I remember reading somewhere that performing mysql_query() in loops can be damaging to the database.

 

Is it possible to avoid that damage by using usleep() function?

 

Something like:

for($i=0; $i<100; $i++)
{
mysql_query($sql);
usleep(10);
}

 

If it is possible to do so, what should be the value of usleep seconds? Will 10 microseconds be enough or any other value you recommend? I will be performing about 200 queries in the loop.

 

Thank you.

-Rohan

[phpzone]

Why do you need to do 100 separate queries in one go?

 

Are you sure what you are trying to do is not possible in a different way?

 

More details may help someone establish whether what you are doing is the best way or if you can re-write your

query.

 

This is more a MySQL question rather than PHP however

 

[Rohan Shenoy]

^There is no other way it can be done.

 

offtopic: I have reported this topic to be moved to MySQL forum.

[fenway]

^There is no other way it can be done.

hard to believe....