SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2007
    0 Post(s)
    0 Thread(s)

    Talking InnoDB v myISAM v database design

    I subscribe to the Sitepoint newsletters but was dismayed to find Craig Bucker's post, dated 19th November 2010, in an email dated 13th December 2011, inviting further comment.

    The post is closed for comments; despite the email inviting further comment, which is a bit annoying, given the 'heated discussion' that appeared to erupt over the choice of storage engine.

    I like InnoDB for it's FKs but then I am not running a demanding environment, where data access times are a problem.

    I haven't read all the comments yet, there were some claims on speed and performance in both camps but no one appeared to query the underlying database design.

    I perceive PHP to have a much lower entry bar than, say Perl or C++. This may allow for the introduction to MySQL and databases to people who don't realise they have to clean their user input.

    If people haven't researched much about securing their web application, be it a simple form or something more complex, then might it be a good bet they probably don't know too much about what is reasonable in database design either? That would result in a number of people not even thinking about which storage engine they might need.

    Surely the database design will have an effect on performance; part of the design brief should be to assess which dbms and, in the case of MySQL, which storage engine best answers the project's demands?



  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Toronto, Canada
    63 Post(s)
    3 Thread(s)
    it's unfortunate that you were so recently invited to read an old article

    but the article itself is pretty good

    i kinda skimmed over the comments, a lot of people getting their shirttails in a knot for nothing | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

Tags for this Thread


Posting Permissions

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