Raised This Month: $ Target: $400
 0% 

hlds - sql


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
zeus
Senior Member
Join Date: Jul 2008
Old 07-13-2010 , 05:06   hlds - sql
Reply With Quote #1

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
zeus is offline
Sylwester
Veteran Member
Join Date: Oct 2006
Location: Poland
Old 07-13-2010 , 05:09   Re: hlds - sql
Reply With Quote #2

Use SQL_ThreadQuery to get data from your mysql database.
http://www.amxmodx.org/funcwiki.php?go=func&id=1100
__________________
Impossible is Nothing
Sylwester is offline
zeus
Senior Member
Join Date: Jul 2008
Old 07-13-2010 , 05:52   Re: hlds - sql
Reply With Quote #3

I am already using that.
zeus is offline
Sylwester
Veteran Member
Join Date: Oct 2006
Location: Poland
Old 07-13-2010 , 08:53   Re: hlds - sql
Reply With Quote #4

I don't think so. If you use it correctly, then it will never cause lag.
__________________
Impossible is Nothing
Sylwester is offline
Alka
AMX Mod X Plugin Approver
Join Date: Dec 2006
Location: malloc(null)
Old 07-13-2010 , 09:55   Re: hlds - sql
Reply With Quote #5

Quote:
Originally Posted by Sylwester View Post
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?
__________________
Still...lovin' . Connor noob! Hello
Alka is offline
Sylwester
Veteran Member
Join Date: Oct 2006
Location: Poland
Old 07-13-2010 , 10:40   Re: hlds - sql
Reply With Quote #6

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.
__________________
Impossible is Nothing
Sylwester is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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