Raised This Month: $ Target: $400
 0% 

[sorting] SQL vs SQLITE vs NVAULT


Post New Thread Reply   
 
Thread Tools Display Modes
aron9forever
Veteran Member
Join Date: Feb 2013
Location: Rromania
Old 06-04-2014 , 02:39   Re: [sorting] SQL vs SQLITE vs NVAULT
Reply With Quote #11

Quote:
Originally Posted by devilicioux View Post
Sorry for the late bump ..

I made a XP plugin based on nVault .. it seems to be awesome(basis of reviews i got on that) and i am working more on it to make it distinguishable from rest Xp mods that exist.
Any there any way i can get rank of any player(not just the top15 .. I did implement TOp15 and works fine) in the list on realtime basis from the nvault database just like HLX stats ? Will such realtime sorting consume a lot of CPU ?
sorry to burst your bubble bro but nvault is the worst solution for that, if of course you are running a public server and not a clan wars or something
view it like this, my server's had over 15000 unique scoring players over the last year, if a user joins, his info is at the end of the vault, now guess how much it would take for the server to process the entire string till it gets to the last player

reading 600 admins from sql tho takes less than a second, so you get the difference

I just don't understand why people won't use sqlite / sql , there are tutorials out there that make it easy as hell, there's even one for a simple xp mod

Last edited by aron9forever; 06-04-2014 at 02:40.
aron9forever is offline
devilicioux
Veteran Member
Join Date: Jun 2013
Location: Delhi,India
Old 06-04-2014 , 05:39   Re: [sorting] SQL vs SQLITE vs NVAULT
Reply With Quote #12

Quote:
Originally Posted by aron9forever View Post
sorry to burst your bubble bro but nvault is the worst solution for that, if of course you are running a public server and not a clan wars or something
view it like this, my server's had over 15000 unique scoring players over the last year, if a user joins, his info is at the end of the vault, now guess how much it would take for the server to process the entire string till it gets to the last player

reading 600 admins from sql tho takes less than a second, so you get the difference

I just don't understand why people won't use sqlite / sql , there are tutorials out there that make it easy as hell, there's even one for a simple xp mod
yeah .. SAD ENOUGH !! .. Can you redirect me to that sql tutorial related to simple xp mod you talking about ?
__________________
You keep bringing ANTICHRISTUS down .. He will rise again and kick asses !

#RespectList ANTICHRISTUS fysiks Bugsy

Most Common Errors You Can Encounter Every Now and Then

Last edited by devilicioux; 06-04-2014 at 05:40.
devilicioux is offline
aron9forever
Veteran Member
Join Date: Feb 2013
Location: Rromania
Old 06-04-2014 , 11:31   Re: [sorting] SQL vs SQLITE vs NVAULT
Reply With Quote #13

Quote:
Originally Posted by devilicioux View Post
yeah .. SAD ENOUGH !! .. Can you redirect me to that sql tutorial related to simple xp mod you talking about ?
here you go broski
https://forums.alliedmods.net/showthread.php?t=132686
aron9forever 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 09:47.


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