+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Accessing query results incredibly slow (/showthread.php?tid=47605)
Accessing query results incredibly slow - El Forum - 12-14-2011
[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?
Accessing query results incredibly slow - El Forum - 06-10-2012
[eluser]mobs6[/eluser]
Well, i just want to shared if u dont want use the odbc with MSSQL, u could see this forum:
http://ellislab.com/forums/viewthread/213879/