RE: Best update strategy with MyISAM

2007-03-03 Thread mos
Schwenke, Senior Software Developer, MySQL AB > -Original Message- > From: mos [mailto:[EMAIL PROTECTED] > Sent: Friday, March 02, 2007 7:39 AM > To: mysql@lists.mysql.com > Subject: Best update strategy with MyISAM > > I will have an application that will have 1000 2

RE: Best update strategy with MyISAM

2007-03-02 Thread Gary W. Smith
ing a storage engine.XL -- Axel Schwenke, Senior Software Developer, MySQL AB > -Original Message- > From: mos [mailto:[EMAIL PROTECTED] > Sent: Friday, March 02, 2007 7:39 AM > To: mysql@lists.mysql.com > Subject: Best update strategy with MyISAM > > I will have an ap

Best update strategy with MyISAM

2007-03-02 Thread mos
I will have an application that will have 1000 20 row selects executed every second. The application will also be updating individual rows from this table at a rate of 100 rows/second. I prefer to use MyISAM instead of InnoDb because eventually the table will exceed the amount of memory on the