AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   hlds - sql (https://forums.alliedmods.net/showthread.php?t=132239)

zeus 07-13-2010 05:06

hlds - sql
 
I have a plugin installed on the server that stores data in a mysql database
The problem is that the latency between the sql and the hlds is about 150ms and every time the server gets data from the sql the server hangs
How can I avoid this? A bypass or something :|

Sylwester 07-13-2010 05:09

Re: hlds - sql
 
Use SQL_ThreadQuery to get data from your mysql database.
http://www.amxmodx.org/funcwiki.php?go=func&id=1100

zeus 07-13-2010 05:52

Re: hlds - sql
 
I am already using that.

Sylwester 07-13-2010 08:53

Re: hlds - sql
 
I don't think so. If you use it correctly, then it will never cause lag.

Alka 07-13-2010 09:55

Re: hlds - sql
 
Quote:

Originally Posted by Sylwester (Post 1237656)
I don't think so. If you use it correctly, then it will never cause lag.

What about 20 queryes in less than a second?

Sylwester 07-13-2010 10:40

Re: hlds - sql
 
As far as I know, only one query can be handled at the same time, so even if you execute SQL_ThreadQuery many times in one second, it will not cause lag (queries will queue up), but it will take some time before you get results for all of them.


All times are GMT -4. The time now is 07:16.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.