1 Topic by lowboy (edited by lowboy 2007-03-02 22:23)

  • lowboy
  • Junior Member
  • Offline
  • Registered: 2007-03-01
  • Posts: 2

Topic: Disadvantages to converting "user" table to InnoDB? - Thanks Rickard!

I have some other application tables that depend on the PunBB user and I want to use foreign keys to ensure data consistency. MyIsam doesn't support foreign keys, so I'd need to switch to InnoDB.

I'm wondering about possible disadvantages to switching the table engine as the number of users/posts/forum-activity scales up.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Disadvantages to converting "user" table to InnoDB? - Thanks Rickard!

For the users table, it shouldn't really matter. Go ahead.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • lowboy
  • Junior Member
  • Offline
  • Registered: 2007-03-01
  • Posts: 2

Re: Disadvantages to converting "user" table to InnoDB? - Thanks Rickard!

Thanks for the quick answer Rickard!