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

[CS GO] EXP Mod


Post New Thread Reply   
 
Thread Tools Display Modes
_AeonOne_
Member
Join Date: Nov 2012
Location: Berlin, Germany
Old 04-08-2015 , 02:08   Re: [CS GO] EXP Mod
Reply With Quote #11

Okay
Performance:
2000 Players is not really a "big" dataset depending on your table sizes.
MySQL does perform better on big datasets and has a greater datathroughput. But as I already said: 2000 Players is not a big set..(i would prever mysql anyway though)
(Also do every optimization you can, at example an auto incrementing integer id as the default key)
(@ example i've created in the past a vip plugin for my server. The DB was mysql driven with multiple tables containing ~75-80 thausend players. Even the non threaded querys where fast enough to not cause laggs [i've used threaded anyway though since it prevented laggs on roundend {when all save querys must be send}])

I don't know how querys can be made in amxx mod but sourcemod gives you the ability to use threaded querys. They do not corrupt the execution of the main thread and therefore don't cause laggs (no matter how slow your db is)
You should do every call with it. This needs a more expanded way with dealing with data though since there is a time-gap between query and query-result. (This can cause racing-conditions you should avoid)
_AeonOne_ 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 13:47.


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