[TinyOWS-users] Speed of GetFeature Request with 4 millions point

[Marc-André Trottier]

there is the diff with rc4.

i switched all the WHERE clause for a INNER JOIN ON INTERSECT.
i do the transformation on the POLYGON and not the geometry of the table.
the request does one transformation on the polygon and not many
transformation as the WHERE clause.

and i thought about my srid problem, and maybe i don't need the table's
srid.
if the layer's srid is always the same of the table's srid.
ows_srs_get_srid_from_layer() return the srid of the tag "wfs_srs" in my
mapfile ?

Marc-André Trottier
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-users/attachments/20110818/69118452/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: modif_wfs_get_feature.patch
Type: application/octet-stream
Size: 831 bytes
Desc: not available
Url : http://lists.maptools.org/pipermail/tinyows-users/attachments/20110818/69118452/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: modif_fe_spatial_ops.patch
Type: application/octet-stream
Size: 2670 bytes
Desc: not available
Url : http://lists.maptools.org/pipermail/tinyows-users/attachments/20110818/69118452/attachment-0001.obj