On Fri, Sep 4, 2009 at 4:12 AM, Mangesh Sathe<mang...@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 _______________________________________________ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show_participation.php