Hi,
In https://docs.geotools.org/stable/userguide/library/data/mongodb.html <https://docs.geotools.org/stable/userguide/library/data/mongodb.html> under Implementation Notes it says - Bounding box calculation makes use of a full table scan. but in https://github.com/geotools/geotools/blob/main/modules/plugin/mongodb/src/main/java/org/geotools/data/mongodb/MongoDataStore.java BBOX capability is added. Technically the BBOX should be a $geoWithin query with a 4 points polygon. https://www.mongodb.com/docs/manual/tutorial/query-a-2dsphere-index/ Using the OpenLayers map preview and zooming in I can see in the MongoDB server logs that no filter is used and a COLLSCAN is issued! "attr":{"query":"ns: sweden.landuse query: {} sort: {} projection: { geometry: 1 }","planSummary":"COLLSCAN"} It seems that the MongoDB instance is not breaking a sweat at the collscan but Geoserver grinds to a halt, trying to crunch the data in-memory most likely. Is there a bug report or feature request tracking this? Maybe I could get this fixed if someone points me to where the action is (not) happening :) I also noticed https://stackoverflow.com/questions/61178776/how-to-get-geoserver-to-use-the-mongodb-geo-index-for-heatmap-transformations but have not found a way to verify if that's been fixed, but maybe you know? Happy to help out if I can get some pointers. Btw generating the schema seems to be an awesome feature! Best Regards, Johannes { name : "Johannes Brännström", title : "Senior Solutions Architect", phone : "+46(0)725109160", location : "Stockholm, Sweden", linkedIn : "in: johannesbrannstrom <https://www.linkedin.com/in/johannesbrannstrom>", web : "www.mongodb.com" }
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
