How can Create OVF file (for OGR MYSQL connection) interactively

[Howard Butler]

Murat,

If you are using the OGR connector for MySQL (and not the MyGIS one 
that can be used with MapServer), OGR will need to make an entire 
pass through the table to calculate the extent for the layer to 
satisfy calls to msLayerGetExtent.  Unfortunately, setting an EXTENT 
for the layer does not seem to short circuit this call in either 4.8 
or 4.10. It is possible (although I haven't looked and can't confirm) 
that setting wms_extent for the layer might short-circuit the request 
for the layer's extent and save an extra troll through the layer. I 
hope to resolve this issue in 5.0.

Howard


At 01:37 AM 9/20/2006, Murat BEYHAN wrote:
>Dear Friends,
>
>I'm using Mandrake Linux 2005 limited edition on my computer which is pentium
>4 3.0Ghz, 512MB RAM and the HD was divided 2 part one for the Windows XP.
>Linux uses 40GB.
>  MySQL4.1.18.
>  Mapserver4.8.4
>  php4.4.4
>
>And I have measured the elapsed time for my study on my computer (as 
>localhost)
>
>I'm connecting MySQL and drawing PGA distribution of an earthquake. The PGA
>data of the earthquake which I select use 40000 row in my database. And each
>line include Earthquake ID latitude longitude and PGA values.
>When I try to draw it on my machine It take 22 second.
>I'm not familiar to use phpmapscript so I have just used HTML code 
>to draw map .
>I don't have any idea about the time it is acceptable or not. May I draw map
>in shorter time than 24 sec. by using PHPmapscript. I mean is it possible to
>increase the perfrmance of my aplication. Could you make some disscusion about
>this issue...
>
>Thank you
>
>Murat
>
>--
>This message has been scanned for viruses and
>dangerous content by MailScanner, and is
>believed to be clean.