Mysql Optimizer - where did it go?

[akpcep]

Hi,

I seem to remember there was a little script you could run that added extra indices to the Yabb tables - I've been searching these boards for an hour but all the links to it are dead. Can someone please point me to it's current location?

Many thanks.

[[Unknown]]

Well, you don't want *extra* indexes or anything, just the right amount of them.

However, if you click the "Optimize Database" link in your admin center it should speed things up a little.

-[Unknown]

[akpcep]

Thanks for your reply!

I think I found a thread in which the indices were listed, and my install already had them all. I've turned off the click log and stats and what have you so I think it's about as fast as it's going to get.

Hey ho!