Hi Neil, Recommend : Innodb storage engine
Even, i would suggest inner join select query (if report query might takes few seconds) should be executed on slave. Before doing any thing. Plan out all the requirement. Regards, Krishna On Thu, Mar 18, 2010 at 2:48 PM, Tompkins Neil <neil.tompk...@googlemail.com > wrote: > Hi > > I'm currently looking to develop an on line web application - which is > going > to be used by around 200+ concurrent users at any one time. Can > you recommend to me the best/preferred MySQL database engine to use for > example MyISAM ? > > Also, in your experiences, do you recommend that SELECT statements > containing a number of INNER JOINS should be execute from a Stored > procedure > or purely from the webpage ? > > Cheers > Neil >
