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 that very fast (since it's a common operation) PostgreSQL does it for example. SQLite + GeoPackage does not (for now, I may have an opportunity to look at it later down the road and improve it) Cheers Andrea On Sat, May 30, 2020 at 2:00 PM David Adler <dwa12...@gmail.com> wrote: > 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 much much faster. When the DB2 filter code gets control, > it doesn't have access to the data bounding box in order to change the > behavior, as far as I can tell. > > Is this behavior expected? > > > -- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > > > _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel > -- Regards, Andrea Aime == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- *Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.*
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
