Originally Posted by Varius

I'm just curious if GFY's tech have tried yet to convert the board tables into InnoDB. It's quick and painless to do, and is built exactly for millions of rows of data and providing speed.

I would assume they are already using row-level locking even with INNODB (if not, there's 99% of your problem right there), but InnoDB can still provide immediate advantages without touching the vb code at all.

They should atleast try a benchmark: copy their largest table and make it InnoDB, then run a few searches on the current version versus the InnoDB version and see what your results look like.

Small tables have been proven faster in INNODB from my experience, but once you get past 500,000 rows or so, InnoDB outperforms it. With 5-10 million rows or more, it outperforms it drastically.

Anyhow, if they want to try, "ALTER TABLE tbl_name TYPE=InnoDB" is all you need