Is there a good reason not to...

[Carnage]

... change the vbulletin default tables to use the INNODB storage engine?

I'm writing a mod and i want to use forign key contraints against a couple of tables... for that to work they have to be innodb...

[Marco van Herwaarden]

Not for any searchable table like post.

[Carnage]

is that saying theres no reason not to?

My thinking on this: on the surface, innoDB seems to be a better engine, however there must be a reason most things (like vb) use myisam... i refuse to believe its all done out of lazyness...

[Lynne]

If you want more detail or specifics, this might be a question best addressed to the developers over at vb.com

[Marco van Herwaarden]

Searchable tables like the post table must use MyIsam or you would not have the option to use the MySQL Full Text Search.

[Carnage]

bit of an annoyance... one of the tables was the thread table.

Guess i have to write code to do it instead... or perhaps use triggers...