Raised This Month: $51 Target: $400
 12% 

sql plugin issue


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Sanjay Singh
Veteran Member
Join Date: Sep 2016
Old 11-29-2019 , 13:53   sql plugin issue
Reply With Quote #1

when i use sql plugin and i change map, it takes 5-6sec to change the map.

whats the issue & how can i solve it?
__________________
Sanjay Singh is offline
Send a message via AIM to Sanjay Singh
OciXCrom
Veteran Member
Join Date: Oct 2013
Location: Macedonia
Old 11-29-2019 , 14:01   Re: sql plugin issue
Reply With Quote #2

Slow SQL connection.
__________________
OciXCrom is offline
Send a message via Skype™ to OciXCrom
Sanjay Singh
Veteran Member
Join Date: Sep 2016
Old 11-30-2019 , 10:25   Re: sql plugin issue
Reply With Quote #3

Quote:
Originally Posted by OciXCrom View Post
Slow SQL connection.
and how can i fix it?
__________________
Sanjay Singh is offline
Send a message via AIM to Sanjay Singh
redivcram
Veteran Member
Join Date: Jul 2014
Location: Serbia
Old 11-30-2019 , 10:36   Re: sql plugin issue
Reply With Quote #4

Quote:
Originally Posted by Sanjay Singh View Post
and how can i fix it?
Host your SQL server with a better internet.

Last edited by redivcram; 11-30-2019 at 13:25. Reason: confusion, check reply below
redivcram is offline
Sanjay Singh
Veteran Member
Join Date: Sep 2016
Old 11-30-2019 , 11:39   Re: sql plugin issue
Reply With Quote #5

Quote:
Originally Posted by redivcram View Post
Host your server with a better internet.
lol server running on 1GBps Port so i dont think server speed is the issue.
__________________
Sanjay Singh is offline
Send a message via AIM to Sanjay Singh
OciXCrom
Veteran Member
Join Date: Oct 2013
Location: Macedonia
Old 11-30-2019 , 13:15   Re: sql plugin issue
Reply With Quote #6

SQL server speed, not CS server.
__________________

Last edited by OciXCrom; 11-30-2019 at 13:16.
OciXCrom is offline
Send a message via Skype™ to OciXCrom
JocAnis
Veteran Member
Join Date: Jun 2010
Old 11-30-2019 , 13:21   Re: sql plugin issue
Reply With Quote #7

are you sending any query on map restart?
are your cs server and sql server geography near, because of ping?
__________________
KZ Public Autocup - PrimeKZ

My blog: http://primekz.xyz (in progress...) - not active (dec 2022)
JocAnis is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 11-30-2019 , 13:27   Re: sql plugin issue
Reply With Quote #8

Use a threaded query on server start if you are not doing so already.
__________________
Bugsy is offline
Sanjay Singh
Veteran Member
Join Date: Sep 2016
Old 11-30-2019 , 13:42   Re: sql plugin issue
Reply With Quote #9

gameserver in mumbai & sql server in singapore will it effect much?
__________________
Sanjay Singh is offline
Send a message via AIM to Sanjay Singh
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 19:21.


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