MySQL connection freezes via SQL_FastQuery
 

Have a one of problem. MySQL server located not in same location where srcds server located. Difference in 60-80ms between them. And client occurs a lag when I used SQL_FastQuery stock by chat trigger. For example u write something in chat and it's saved in db. I don't understand why it happens, why sourcemod not used multithreading with mysql ext :cry: net_graph reports that sv and var ups to 10ms when SQL_FastQuery used. Last time I thought that mysql server not enought optimized but after configuration updates I understood that problem happens due to sourcemod.. because last experience tell me same when I used MySQL on same machine with SRCDS, lags happens, but not as when distance amount between servers is 60-80ms I thing that sm team must rewrite old part of mysql ext and fix problem with threading

Re: MySQL connection freezes via SQL_FastQuery
 

The MySQL extension does support threading, you just have to use SQL_TQuery.

Re: MySQL connection freezes via SQL_FastQuery
 

...what the? OP lazy to read SM wiki and old topics?

Re: MySQL connection freezes via SQL_FastQuery
 

Yes. It's. Not enought time for this. bro.. I ask and subscribe to the my treads only, for future if problem happens again.

Re: MySQL connection freezes via SQL_FastQuery
 

Thanks. Very shortly and helpfully. +rep