[mapguide-users] Scripts timing out I think

[George McLean]

I am using Apache/PHP with MGOS 1.2 querying against MySQL using FDO.

I have a query that returns line entities based on user input to the 
query. For each geometry returned, I am creating a line feature on a 
temporary line layer. This works well since I can control the color and 
line width of the lines indicating the selected items.

My problem is when I get large result sets (~7500 lines) from the query. 
It appears that the script never finishes. I get some of the lines I 
expect but not all of them. If I turn off the line drawing routine, the 
script does finish but of course I get no lines. This leads me to 
believe the script is timing out.

Any suggestions on how to do this more efficiently? I am adding insert 
commands to a MgFeatureCommandCollection object as I step through the 
result set and then updating and saving the updates once after looping 
is finished.

Are there settings that would extend how long this script can run?

I looked at the following settings but was not sure what to try and 
change. Any suggestions before I start hacking?

Mapguides serverconfig.ini:
   
    ConnectionTimeout = 120
    DataConnectionTimeout = 600
    SessionTimeout = 120

Apache

    Timeout = 300
    KeepAliveTimeout = 15
    FastCgiConfig -idle-timeout = 120
    FastCgiServer -idle-timeout=120

PHP

    max_execution_time = 600

Thanks

George McLean