Results 1 to 4 of 4

Thread: Some questions

  1. #1
    Join Date
    Mar 2010
    Posts
    8

    Unanswered: Some questions

    Hello,

    I'm starting the development of a new project

    The DB will be used to store hundreds of thousands of products ( probably millions), thousands of such products will be updated every day.
    This database will be used to power several websites, I don't expect the traffic to explode on these sites, but I don't want to build something with no chances to perform well.

    MyISAM or INNODB? I continue to find opinions of any kind on this subject

    how would you prevent websites to be slow while the database is being updated ( hence being hit by thousands of SELECT/INSERT/UPDATE queries) ?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by uhm View Post
    MyISAM or INNODB? I continue to find opinions of any kind on this subject
    MyISAM for read-only tables and for fulltext search

    InnoDB for foreign key data integrity and row-level locking on updates

    Quote Originally Posted by uhm View Post
    how would you prevent websites to be slow while the database is being updated ( hence being hit by thousands of SELECT/INSERT/UPDATE queries) ?
    InnoDB
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2010
    Posts
    8
    So you suggest using two separate tables, one Innodb for backend INSERT/UPDATE operations and one, MyISAM, for websites.

    What would be the best approach to create the MyISAM table from the InnoDB table content?

    Simply using something like this?
    Code:
    CREATE TABLE aaa SELECT * FROM products;
    are there smarter/faster methods?

    What about a view?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by uhm View Post
    So you suggest using two separate tables, one Innodb for backend INSERT/UPDATE operations and one, MyISAM, for websites.
    that's not exactly what i meant

    i would use innodb exclusively unless i had a reason to need myisam, and then i would not duplicate the data either
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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