Thanks for all the responses and useful information.
Cheers
Neil
On Thu, Mar 18, 2010 at 6:35 PM, mos 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 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 exp
Thanks for the useful information. Can you let me know any other things I
need to consider ?
Regards
Neil
On Thu, Mar 18, 2010 at 9:50 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Neil,
>
> Many times we need to generate reports (weekly, montly, yearly) from the
> data we
Hi Neil,
Many times we need to generate reports (weekly, montly, yearly) from the
data we have. For detailed reports we have to use joins on many tables. So,
it takes time from 2 to 5. So these types of activities must be performed on
slave server.
If you need reports then you should have master
Hi
How do you mean "executed on slave" ?
Neil
On Thu, Mar 18, 2010 at 9:32 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Neil,
>
> Recommend : Innodb storage engine
>
> Even, i would suggest inner join select query (if report query might takes
> few seconds) should be execu
Hi Neil,
As Krishna said, Innodb is generally always superior to MyISAM unless
you need full-text search (and even if you do there are alternatives to
MyISAMs full-text search, which I've often found to be lacking in
performance).
A poorly optimised query will be slow whether it is called from a
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 wrote:
> Hi
>
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 stateme
