Welcome Guest, Not a member yet? Register   Sign In
Accessing query results incredibly slow
#1

[eluser]alboyd[/eluser]
Hi Guys,

This is really strange! I have a ODBC connection to a MSSQL 2008 database. I am running a query which is returning 3200 rows and the query executes within 0.5 seconds.

I assign the result to $result and I return this to my controller.

If that is all I do then the controller executes in 0.5 seconds.

If however I try and access a row within the $result such as

Code:
echo var_dump($result->row(0));

The controller takes 110+ seconds to execute and then correctly echo's the var_dump. If I try and do ANYTHING with $result it takes this long... I'm totally stumped!

I hope someone has an idea of what might be going on here?


Messages In This Thread
Accessing query results incredibly slow - by El Forum - 12-14-2011, 11:43 PM
Accessing query results incredibly slow - by El Forum - 06-10-2012, 12:43 AM



Theme © iAndrew 2016 - Forum software by © MyBB