i installed a module on both of my sites. it does the same (and more) as the sql scripts i posted earlier on this thread..... Every now and again i hit the clean buttons.
I get tones of bots too. Sped the sites up - but note: you'll kill any customers checkouts so i press the clean button when i'm not anticipating many orders.
!!!!Def backup your db before you install it and press any buttons!!!
https://mypresta.eu/modules/administration-tools/database-optimization.html
