Posted by balwant singh on 07/23/05 11:02

Hi,

I have made a webpage in php which retrieves the data from a huge MYSQL
tables as below:-

$i=0;
while ($i<=23)
{
select a, b from table where hour(time)=$i and date='' order by desc
time limit 1;
$i++;
}

then i substract the current hour output from the last hour output for
calcuating the output in that hour through PHP code and then display it.

But my problem is that this page takes approx. 90 seconds or more for
loading even when i refresh the page, it is taking the same time.

I have done indexing on that table, tune the php and apache but it is
still taking same time.

I have other tables also when PHP is doing more calculatios but those
pages are not taking so much time they load in 5 sec. or so.

Is there anything needs to be done more, please advise.

--
With Best Wishes

Balwant Singh

• Next in forum: Re: [PHP] speed - PHP/MYSQL
• Prev in forum: Re: [PHP] On register_shutdown_function: What might be the problem?
• Thread view: [PHP] speed - PHP/MYSQL

[Reply to this message]