I have been struggling with improving the web loading time for a php page and there is not improvement in it. I do know that the php page slows down just because of the complex sql query being run in teh for loop for 100 times.
Does anyone know how to improve it so that the web loading time for the php page would improve?
Something similar would be
Code: Select all
for(i=0i<ctr;i++)
{
select table1.A,table2.B,C,D,E,F,G,H,I,J from table1,table2 where B='var1' and ((datevar between 'D' and 'E')or (datevar between 'D' and 'E')) and table1.A like'somevalue%' and table2.B='somevalue' and E like 'var23'
print *************;
}
Thanks,
Tresa