[Tiki-devel] Poor performance on doc (maybe dev too) hopefully fixed

I started trying to fix the missing images on http://doc.tiki.org/PluginImg but needed to check in the file galleries, which have been broken there for months, so i investigated...

And eventually, found there were about 2 million expired auth tokens in the database (generated when pages are printed i think), due to some poor code in \AuthTokens::getGroups, which i (hopefully) have fixed in:

    https://gitlab.com/tikiwiki/tiki/-/commit/5292fbdf

I've also backup up and removed all the expired tokens from the tiki_auth_tokens table on doc, and now we have filegals back again, woo!

e.g. 

    https://doc.tiki.org/file5

Seems that table on dev also has about 1.5 million row, so i'll do the same expiry delete query there too...

And once the tikis there have updated (usually overnight i think) this shouldn't happen again - hopefully...

jonny