Welcome Guest, Not a member yet? Register   Sign In
0.5s query takes 13s to run 4 times
#1

[eluser]sigsauer[/eluser]
I'm looping a query to fetch price history for 4 different items.

The query takes half a second to run, but putting it in a loop to run 4 times takes too much time.

Is it because it is connecting and disconnecting to/from the database every time?

Thanks!


Messages In This Thread
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 12:38 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 01:00 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 01:51 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 02:16 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-06-2010, 03:31 AM
0.5s query takes 13s to run 4 times - by El Forum - 08-09-2010, 03:49 AM



Theme © iAndrew 2016 - Forum software by © MyBB