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.
