Quote Originally Posted by jeking View Post
It at the end of includes/configure.php called define('SQL_CACHE_METHOD', 'database');

I believe database, file and none are options. If I remember correctly (which is dangerous), file is recommended for small to medium sites and database for large ones. But the database method can cause large databases. I'm not sure why mine is database (set it up too long ago to remember) but it should probably be file.

I'd be a little concerned about an automated way to remove things from the db. I'd think doing it manually, backing up first, is best. That way you know 'exactly' what's being removed.
I have been manually doing that. Still seems rather large though. I think the xsell table just is what it is and we'll have to deal with it.