Thread: [Bug Report] Banlist slow loading query on recent MYSQL versions
View Single Post
theChaosCoder
Junior Member
Join Date: Oct 2015
Old 10-28-2016 , 17:41   Re: Banlist slow loading query on recent MYSQL versions
Reply With Quote #2
Which mysql version are you using?

I tested it on my server and it's super fast 0.001 sec for ~3400 rows (bans). I'm using MariaDB 10.1.14 (Table type InnoDB)

Your "optimized" query is actually slightly slower (0.0058 ) on my server because there are now 2 queries


Maybe you have a config issue?
As far as I could see you have 9263 bans, which is nothing for a where query.
Last edited by theChaosCoder; 10-28-2016 at 17:52.
theChaosCoder is offline