Hi list,
how is maxfeatures handled in Geoserver when having an Oracle Spatial
datastore?
In the generated SQL I don't see any mention of ROWNUM (ROWNUM <=
[maxfeatures], does this mean the whole table is requested to Oracle and
Geoserver filters out the first X rows itself?
Best regards,
Bart
No, the whole table is not requested. Javier was also asking this with regards to PostGIS, no LIMIT set. GeoServer streams data from the JDBC connections, tables are so big that it's basically impossible for us to do anything that would load a whole table in to memory. So the maximum number of extra rows that you'll get loading up is the Fetch Size for the database. I think for PostGIS it's about 200 rows at a time, and I imagine Oracle's about the same. Since there's really not a ton of overhead (or is there, are you experiencing massive memory drains?), we didn't both with the step to pass the maxfeatures back to the database. But I don't believe there's much overhead to just closing the pointer to the results in the db when you're done using it.
If people really want the maxfeatures passed back in to the db I can investigate how hard it would be. But although we are filtering out the first x rows in geoserver, we're not really bringing them all in to Java.
Chris
Bart van den Eijnden (OSGIS) wrote:
Hi list,
how is maxfeatures handled in Geoserver when having an Oracle Spatial
datastore?In the generated SQL I don't see any mention of ROWNUM (ROWNUM <=
[maxfeatures], does this mean the whole table is requested to Oracle and
Geoserver filters out the first X rows itself?Best regards,
Bart-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:1003,44bf43a773561336712104!
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org