On Mon, Jul 26, 2010 at 9:12 PM, Balaji Narayanan <lists@xxxxxxxxxxx> wrote:
On 24 July 2010 11:50, Rajesh kumar <rkrajeshkumar87@xxxxxxxxx> wrote:
Dear Luggies,
I have developed an php appliaction with mysql as background. This
applications main part is data entry, it handles huge no of data, same way
the application is accessed by 3000 people at same time, my db traffic
becomes high and application becomes slow, can you suggest me some of
methods so that i can optimize the database. say like creating stored
procedures.
The first step to optimize anything is to understand the bottlenecks.
Have you done any analysis to figure out the bottlenecks?
Some things to look at:
* What is causing the db to slow? DB writes or reads?
* Enable slow query logging and check those queries.
* Have you created proper indexes?
* Can data be cached - See a related post on memcached.