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

[Marc-André Trottier]

i'm using the Mr. Leukert's method with a index on st_transform(geom_p,
900913).
it's as fast as the INNER JOIN.
10 seconds with WHERE and 1 second with index and INNER JOIN to do the same
Getfeature request

Marc-André Trottier
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-users/attachments/20110823/e007c80d/attachment.htm