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

Register System Lagging the server


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
D4rkSiD3Rs
Senior Member
Join Date: Jan 2018
Location: Morocco
Old 10-13-2018 , 10:26   Register System Lagging the server
Reply With Quote #1

Hello,

I'm using Register System V9.0 by m0skVi4a ;] on my server, and there are more than 3500 players registered on the server and the regusers.ini file size is 200kb.
The problem is when someone connect to the server, the plugin have to check in regusers.ini if the player is registered or not, then the server freezes for 3 or 5 seconds. And when the map changes the server stop functioning due to the large number of players connecting on the sametime.

So what do you suggest to avoid that lag coming from that plugin ?
__________________


D4rkSiD3Rs is offline
CrazY.
Veteran Member
Join Date: May 2015
Location: SP, Brazil
Old 10-13-2018 , 11:22   Re: Register System Lagging the server
Reply With Quote #2

In this case, switch to MySQL.
__________________








CrazY. is offline
SkazzY
AlliedModders Donor
Join Date: Nov 2014
Location: Forbidden Forest
Old 10-13-2018 , 11:34   Re: Register System Lagging the server
Reply With Quote #3

If you have 3500 different active users registered, you should have the ability to use MySQL (have a forum, private server or something else that gives you access to MySQL).
SkazzY is offline
D4rkSiD3Rs
Senior Member
Join Date: Jan 2018
Location: Morocco
Old 10-13-2018 , 12:17   Re: Register System Lagging the server
Reply With Quote #4

I am looking for a solution other than MySQL
__________________


D4rkSiD3Rs is offline
klippy
AlliedModders Donor
Join Date: May 2013
Location: Serbia
Old 10-13-2018 , 12:22   Re: Register System Lagging the server
Reply With Quote #5

Go with SQLite then.
__________________
klippy is offline
D4rkSiD3Rs
Senior Member
Join Date: Jan 2018
Location: Morocco
Old 10-13-2018 , 15:10   Re: Register System Lagging the server
Reply With Quote #6

Now I can't change the save method, if i changed it all registered users will be deleted.
__________________


D4rkSiD3Rs is offline
CrazY.
Veteran Member
Join Date: May 2015
Location: SP, Brazil
Old 10-13-2018 , 16:05   Re: Register System Lagging the server
Reply With Quote #7

You can do that without lose data, but will take time. Basically, load from ini and insert user reg in dabatase if not exists, if exists load from database. After a time, delete everything related to ini.

Or, delete everything and let your players create account again.
__________________









Last edited by CrazY.; 10-13-2018 at 16:10.
CrazY. is offline
klippy
AlliedModders Donor
Join Date: May 2013
Location: Serbia
Old 10-13-2018 , 16:06   Re: Register System Lagging the server
Reply With Quote #8

I'm sure it's possible to convert from your current format to SQLite easily.
__________________
klippy is offline
CrazY.
Veteran Member
Join Date: May 2015
Location: SP, Brazil
Old 10-13-2018 , 16:44   Re: Register System Lagging the server
Reply With Quote #9

Yes, @OP can also try to loop through the ini file and insert all data in mysql.
__________________









Last edited by CrazY.; 10-13-2018 at 16:49.
CrazY. is offline
D4rkSiD3Rs
Senior Member
Join Date: Jan 2018
Location: Morocco
Old 10-13-2018 , 17:44   Re: Register System Lagging the server
Reply With Quote #10

Actually, I want to leave it like it is, It's easy for me when I want to change the password of someone's.
__________________


D4rkSiD3Rs is offline
Reply


Thread Tools
Display Modes

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:18.


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