Optimize DB for Influx timer?

[rsgua]

Hello i have some problem with time with load db. Can you make sql request for create indexes in your timer? Some maps load a 6 minutes:( I disable influx_zones_checkpoint and db load on few seconds!

[TotallyMehis]

All queries are threaded. I doubt it's any plugins' fault. You sure you didn't load a workshop map and it had to update?

[rsgua]

i dont use workshop map. i use last version of timer from git.

[rsgua]

my base size 60 mb and load so long and i dont use influx_zones_checkpoint. db load on server start up - 60-120 seconds. i think simple ranks make this load so long.

[TotallyMehis]

Are you using SQLite?

[rsgua]

mysql db

[anaether]

@rsgua Do you have already optimized the database server on its own? On my old HLG Surf servers i also had 40mb database but no problems with db load. I can suggest that you optimize your DB Server at first then the plugin.

[maugerb]

You need a good mysql hoster that it.

[rsgua]

db load so long now! on last version! older version load more fast! cRUSHER-HLG i dont know mysql that say this! I know more than you!

[anaether]

I host it on my own database rootserver. Its the same settings like on old HLG-Surf servers

[TotallyMehis]

@rsgua Try recompiling the plugins using the database (core/checkpoint/etc.) with all CREATE TABLE ... queries removed. They should all exist in */db.sp .