[UPHPU] Table Relationships

[Jacob Wright]

I like using constraints in that I can set it up so when I delete a "user"
or "event" or some other database record it can delete all the relevant data
in other tables that only exist for that deleted item. I'm lazy. :)  MyIsam
table type is faster however for a mostly SELECT database. InnoDB is faster
at writes, so for a transactional database which gets lots of writes to it
it is faster.

Now, there is something you might consider. You can have your table(s) that
need the full-text index to be myisam and the others to be innoDB. I believe
the innoDB tables might even be able to have referential integrity checks on
the myisam tables, just not visa-versa. Then again, I may just be brain-dead
and completely wrong.

Good luck!

Jacob Wright