Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    May 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    InnoDB or MyISAM table types?

    Hi Guys, This is Javin here just joined this forum. I have worked in mysql so thought to start posting from this forum. my question is when should we use InnonDB and when should we use MyISAM engines ?

    Thanks
    Javin

  • #2
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts
    if your query will joining tables, you are better off using INNODB. That engine supports foreign key constraints, which help maintain referential integrity.
    bazz
    "The day you stop learning is the day you become obsolete"! - my late Dad.

    Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
    Useful MySQL resource
    Useful MySQL link

  • #3
    New to the CF scene
    Join Date
    May 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    are you sure , MyISAM doesn't support referential integrity , this seems very surprising to me because foreign key is something must have feature or am I missing something, Also is there any way to change the title of post, I received warning for meaning less title , this is for Moderators , Thanks.

  • #4
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    I think posts can be edited for a certain time. I have corrected it for you to something more descriptive.

    Foreign key constraints ARE NOT supported by MyISAM engine as Bazz points out. You can create them but they are not enforced as they would be on INNODB table type.

    Also note that CHECK constraints ARE NOT supported by any engine of MySQL at this time.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •