MySQL Optimization for Server
#4

Quote:
Originally Posted by Calisthenics
View Post
Update data when they change, do not update EVERYTHING when the server closes. Less queries and less data to update at that time will reduce the "hang" time.
I do this anyway.... :P thanks though....

the "hang" im getting is when the server closes, but when the server closes, there shouldnt be much to append to MySQL as it changes as im updating.

I just read Data from MYSQL to display it currently and create the objects/data associated to the values, it doesnt get changed.

like Loading Default Gang HQ entrances,
faction/family IDS and all the custom rank names, car colors etc.

then i setup pickups for the xyz pos saved in mysql, all that stuff, only data that really changes is the player data.

but the GM ive started off of was pBlueG's recent login_system-cache.pwn

And it was fine closing when i first got the script haha
Reply


Messages In This Thread
MySQL Optimization for Server - by SkyFlare - 31.01.2019, 04:15
Re: MySQL Optimization for Server - by SkyFlare - 31.01.2019, 05:05
Re: MySQL Optimization for Server - by Calisthenics - 31.01.2019, 07:32
Re: MySQL Optimization for Server - by SkyFlare - 31.01.2019, 10:32
Re: MySQL Optimization for Server - by Calisthenics - 31.01.2019, 11:04

Forum Jump:


Users browsing this thread: 1 Guest(s)