Database takes like 15 seconds to load

zhell · **Author**

I have a problem where the database takes really long time to load, which imo is pretty annoying and looks unprofessional, is there a way to improve this? It should have no problem load the database i dont have slow internet and im not hosting the database on a toaster so i don't see the problem, thanks in advance guys!

klippy · 06-19-2017 , 16:18 Re: Database takes like 15 seconds to load

What database? Define "load".

zhell · *Last edited by zhell; 06-19-2017 at 16:35.*

databases.cfg, everything in it takes long to load even if its from sqlite or mysql it takes long.

for example i have a timer on my server and the zones takes long to load

**sneaK** · 06-19-2017 , 16:44 Re: Database takes like 15 seconds to load

This could depend on so many things...

Number of players
Efficiency of your timer
Available processing power/speed of where your databases are hosted
Optimization of queries
Number of plugins/servers accessing databases

If you're running cksurf for your timer, it is notorious for having terribly optimized queries, unoptimized (or nonexistent) indexes, etc.

zhell · 06-19-2017 , 19:25 Re: Database takes like 15 seconds to load

Quote:

Originally Posted by sneaK

This could depend on so many things...

Number of players
Efficiency of your timer
Available processing power/speed of where your databases are hosted
Optimization of queries
Number of plugins/servers accessing databases

If you're running cksurf for your timer, it is notorious for having terribly optimized queries, unoptimized (or nonexistent) indexes, etc.

Okay i guess it could be me having around 24 players online thats causing the problem

thanks for the clear answer

**sneaK** · *Last edited by sneaK; 06-19-2017 at 19:32.*

Quote:

Originally Posted by zhell

Okay i guess it could be me having around 24 players online thats causing the problem

thanks for the clear answer

Ideally number of players online at once shouldn't affect database queries significantly, I'm assuming the efficiency of the queries you are using is lacking.

A_RM · 06-20-2017 , 23:00 Re: Database takes like 15 seconds to load

This has been a growing issue for me as well recently. Been using ckSurf 1.19 on a server for about 2 months now and have never had issues with load zones/settings/records etc, they would all load instantly. I've noticed over the last ~2 weeks that it has become very slugish, taking ~15-20 seconds to load.

I'd have to assume this comes from the fact that as the server grows the more player times in the db that the plugin has to query.

Unfortunate

**sneaK** · *Last edited by sneaK; 06-20-2017 at 23:06.*

Pretty much. cksurf's database setup and queries are horrendously optimized, let alone the code for the timer itself. Poke through the cksurf thread if you're feeling motivated, there are some modified/improved queries scattered in there. I think there was also a script written up by someone to delete inactive users or players with 0 points which would help in this case.