Posts: 845
Threads: 3
Joined: Jun 2010
Quote:
Originally Posted by Riddy
Just wondering, can the MySQL lag out due to that fact that it I'm loading 300 rows at a constant like almost instantly, and the server seems to lag out after they are done, can this be the mysql server itself? or is this a problem with the loop loading and then going through a second function to create objects?
|
Hard to say. It also depends how many columns you are loading (the number of fields fetched by the query is important, rows*columns). However, it's likely that the MySQL plugin causes this if the lag occurs before the result-callback is called. Why don't you use the profiler plugin or just disable the object creating code and find the cause?