|
From: "Manoj Singh" on 18 Jul 2008 08:53 Hello All, I am developing the web site in PHP using MYSQL database. Can you please provide me some tips to write the optimized code. Best Regards, Manoj Kumar Singh
From: Stephen on 18 Jul 2008 08:58 Manoj Singh wrote: > I am developing the web site in PHP using MYSQL database. > > Can you please provide me some tips to write the optimized code. > Hard to be specific without a more detailed understanding of what you are going to do. But in general, use the newer PDO class instead of the older mySQL functions. PDO is better at handling demanding SQL activity. Stephen
From: Schiz0 on 18 Jul 2008 09:18 On Fri, Jul 18, 2008 at 8:53 AM, Manoj Singh <manojsingh2121(a)gmail.com> wrote: > Hello All, > > I am developing the web site in PHP using MYSQL database. > > Can you please provide me some tips to write the optimized code. > > Best Regards, > Manoj Kumar Singh > A opcode cacher helped me a lot on my site. I got the forums loading in more than half the time previously. Quick Description: Every time a php script is called, the CPU compiles that script into executable code, then runs it. An opcode cacher caches that executable code, so the CPU doesn't need to compile it again over and over. Personally, I'm using XCache. http://xcache.lighttpd.net/
From: Sancar Saran on 18 Jul 2008 09:47 On Friday 18 July 2008 15:53:06 Manoj Singh wrote: > Hello All, > > I am developing the web site in PHP using MYSQL database. > > Can you please provide me some tips to write the optimized code. > > Best Regards, > Manoj Kumar Singh Premature optimization as root of all evil. Use less sql connection as possible. If you had opcode cache, put everthing in php code then include it. Do not use, template system, use inline php code for templates. Regards
From: Aschwin Wesselius on 18 Jul 2008 09:52
Sancar Saran wrote: > On Friday 18 July 2008 15:53:06 Manoj Singh wrote: > >> Hello All, >> >> I am developing the web site in PHP using MYSQL database. >> >> Can you please provide me some tips to write the optimized code. >> >> Best Regards, >> Manoj Kumar Singh >> > > Premature optimization as root of all evil. > The Fallacy of Premature Optimization: http://www.acm.org/ubiquity/views/v7i24_fallacy.html So, let's define premature please.... -- Aschwin Wesselius /'What you would like to be done to you, do that to the other....'/ |