On 26 July 2010 21:32, Girish Venkatachalam <[email protected]> wrote: > 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
Though my experience with php is limited and I personally prefer perl, I think such a blanket statement could be misleading. Also, with stuff like APC cache, the application can be made to respond faster. IMO, in this case as the OP says DB traffic becomes high, I doubt if it is going to help. -- http://balajin.net/blog http://flic.kr/balajijegan _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
