Thanks for all the responses and useful information. Cheers Neil
On Thu, Mar 18, 2010 at 6:35 PM, mos <mo...@fastmail.fm> wrote: > At 04:18 AM 3/18/2010, Tompkins Neil 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 ? >> > > > Neil, > I would recommend using MyISAM if the queries where 90% reads and less > than 10% writes. Since you are running a webpage you will of course need to > use parameterized queries to avoid sql injection attacks. Innodb is fine if > the table is small enough that it will fit into memory. If you don't have > enough ram on your machine then innodb can be quite sluggish. If you need > transactions, then Innodb is necessary. > > Mike > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com > >
