From: "Manoj Singh" on
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
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
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
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
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....'/