COmanage Developers List

[Scott Koranda <>]

Hi,

On Sun, Mar 3, 2013 at 1:50 PM, Benn Oshrin 
<>
 wrote:
> On 3/3/13 1:59 PM, Scott Koranda wrote:
>
>> When attempting to query for all email addresses or all
>> identifiers I see this:
>>
>> Fatal error: Maximum execution time of 30 seconds exceeded in
>> /home/skoranda/COmanage/0.7/lib/Cake/Model/Model.php on line
>> 1274
>>
>> I will attempt to work around this for now but we will want to
>> understand why this is happening. The server machine is more
>> than powerful enough to deal with a few thousand rows in a
>> database.
>
>
> Is it timing out on a SQL call or in PHP/Apache?

Editing php.ini and increasing the script time from 30 seconds to 600
seconds made
this problem go away.

I do not know yet if the problem was with the SQL call or the
PHP/Apache call, but
we can easily check tomorrow.

>
> Separate from query optimization (which I agree shouldn't take > 30
> seconds), we should also support pagination.
>

Agreed.

Thanks,

Scott