MySQL Forums :: Newbie :: should i go with myisam or innodb?


Advanced Search

should i go with myisam or innodb?
Posted by: David Brinda ()
Date: August 15, 2009 12:53AM

I'm working on a C++ application that uses a MySQL database to keep track of poker hands and statistics. The table that keeps track of individual hands will have millions of hands in it. I will need to perform simple operations like SUM periodically to generate certain statistics on all of the hands in the database. I'm wondering if I should go with InnoDB or MyISAM for this database? The database will be run on an average PC (2-4 GB RAM) and the operation needs to be done as quickly as possible.

Thanks,
David

Options: ReplyQuote


Subject Written By Posted
should i go with myisam or innodb? David Brinda 08/15/2009 12:53AM
Re: should i go with myisam or innodb? Jay Alverson 08/15/2009 08:33AM
Re: should i go with myisam or innodb? Rick James 08/16/2009 04:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.