Guys, i was looking around my db trying to find ways of bringing the size down when i noticed that the iai_patterns table had two indexes defined for the one column.
phpMyAdmin wrote:PRIMARY PRIMARY 287818 id
id INDEX 287818 id
So in a moment of bravery (or stupidity
) i decided to remove the id INDEX (not the primary index!!) and low and behold it reduced the size of my db by over 3 meg!!
with no obvious ill effects.
keep us updated on this, incase it has any ill effects in the long run
Yeah, please. I wouldn't mind trimming whatever off the DB.
Aha! It appears i misunderstood the Forum Settings.
If you have 'Forum AI is active' set to yes the it will be active in ALL forums unless you set forum overide to be on with a percentage of 0 and Use Words set to off. I was under the impressions that 'Forum AI is active' was a big red switch On or Off
If you have 'Forum AI is active' set to no then you can specifically set it to be on for a forum by setting forum override to be on.
So am I to understand that I'm supposed to set FORUM AI ACTIVE to NO, and then overide for one forum ... or ... set FORUM AI ACTIVE to YES and overide every forum except one?
Hmm ... not the way I thought it worked either, but off to give it a shot.
EDIT: Seems to be working. Even with AI ACTIVE set NO, it's still picking up the 100% overide. Guess it's a little red switch eh?
Thanks for the info netclectic.