mysql query (small doubt)
#5

Quote:
Originally Posted by xVIP3Rx
Посмотреть сообщение
Huge query might take some time to be executed and (With unthreaded queries ) It might cause the server to freezes as much as I know.

You can see how much the execution took by logging the query using mysql_log

Also it's recommended to thread all of your queries to prevent lag/freeze
I've enabled the log and which shows an average of 5000 ms it takes (5 seconds). Thats kinda weird

And how do i thread the query, an example?
Reply


Messages In This Thread
mysql query (small doubt) - by Bondage - 16.01.2015, 15:23
Re: mysql query (small doubt) - by Bondage - 16.01.2015, 16:02
Re: mysql query (small doubt) - by xVIP3Rx - 16.01.2015, 16:26
Re: mysql query (small doubt) - by JeaSon - 16.01.2015, 16:29
Re: mysql query (small doubt) - by Bondage - 16.01.2015, 17:10
Re: mysql query (small doubt) - by xVIP3Rx - 16.01.2015, 17:13
Re: mysql query (small doubt) - by Bondage - 16.01.2015, 17:18
Re: mysql query (small doubt) - by xVIP3Rx - 16.01.2015, 17:22
Re: mysql query (small doubt) - by Bondage - 16.01.2015, 17:29
Re: mysql query (small doubt) - by xVIP3Rx - 16.01.2015, 17:37

Forum Jump:


Users browsing this thread: 2 Guest(s)