RE: [PHP] CPU usage @5% during 2 minutes
| From: | Janke Dávid | Date: | Tue, 19 Oct 2004 22:38:05 +0000 |
| Subject: | RE: [PHP] CPU usage @5% during 2 minutes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-199834@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