RE: [PHP] CPU usage @5% during 2 minutes
| From: | Janke Dávid | Date: | Wed, 20 Oct 2004 10:27:11 +0000 |
| Subject: | RE: [PHP] CPU usage @5% during 2 minutes | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-199863@lists.php.net to get a copy of this message | ||
2004-10-20, sze keltezéssel 00:19-kor Ed Lazor ezt írta:
> > >How any rows are you pulling from the database?
> > aprrox. 12.000 but there are only around 50-100 new rows at a
maximum
> > within a day, and there were almost as many before the
> > problem appeared.
>
> You're creating a form with over 12,000 options in a select statement?
Unfortunately yes. This is a serial code from a paper form. Because they
want to be able to select each form individually from on page there is
no other way.
(maybe I should implement an archivating function)
> Have you tried to increase the amount of memory available to this
script?
Yes.
I have set it to 64M, but it didn't seem to work.
It is strange, that now I have set it to -1 (according to the php doc
this is the value for unlimited memory access). Now it is faster. But by
now I can't say how fast it really is. The customer will say it
tomorrow.
Thanks very much for the help by now