Re: [Geotools-devel] Full bounding box queries

2020-05-30 Thread Jody Garnett
I am not sure I understand, A little greater than the data bounding box - can you provide more information? How does it behave if you zoom out further still? The DB2 code should get a filter and be able to do whatever processing it needs to in order to make a useful query. Many datastore use a vi

Re: [Geotools-devel] Full bounding box queries

2020-05-30 Thread Andrea Aime
Hi David, yes, the behavior is the one expected, a database should be able to fend off by itself in that case, in other words: - Recognize the bbox filter is not selective, and opting for a full table scan - Since all that is requested here is a bbox vs bbox filter, have a way to run t

[Geotools-devel] Full bounding box queries

2020-05-30 Thread David Adler
When using the GeoTools tutorial sample to display a map, modified for DB2, the query generated creates a filter a little greater than the data bounding box. This is time-consuming to process, checking if each feature is within the query area where a straight table-scan of all the data would be