NYCPHP Meetup

[Brent Baisley]

On Fri, Sep 4, 2009 at 4:12 AM, Mangesh Sathe<mangesh at ascellent.co.in> wrote:
> Hello everyone ,
> This is Mangesh Sathe,India..
>
> i have developed one erp website.
>
> As it has large amount of data it takes so much time to load.
> i have  optimised sql queries as well as php code.

You really need to find where the bottleneck is, then focus on that.
If it's just a lot of code or data being moved around, then cache it
and/or create summaries.
If the data doesn't change that often, then you shouldn't rerun the
same queries every time, just save the result.

>
> Any suggestion or Anyone knows ,how can i solve this problem?

Your code may be optimized, but how much of it are you loading at
once? Remember, PHP has reload everything on every hit. Load only
what's needed for the current task. How long does it take your system
to output "Hello World", without putting in any special code to handle
such a simple case?

Brent Baisley


>
> any help would b appretiated
>
> --
> Thanks & Regards,
> Mangesh Sathe