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
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Reply via email to