On Mon, Jul 26, 2010 at 9:12 PM, Balaji Narayanan <[email protected]> wrote: > On 24 July 2010 11:50, Rajesh kumar <[email protected]> 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. >
memcached is a great idea though I have never used it. If you cut over from php to perl, that will help provided you know perl. perl is very fast compared to php. -Girish -- Gayatri Hitech web: http://gayatri-hitech.com SpamCheetah Spam filter: http://spam-cheetah.com _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
