Hi Jody, if with qnx files you refer to spatial index files, actually the response is no. The code only resolves pure alphanumeric filters, and it is cheched before execute this indexing. When an spatial or fid filter is present, then the current behavior in the shapefile provider is respected and the other filters are executed. See:https://github.com/geotools/geotools/compare/master...ahuarte47:GEOS-6842_CdxDbaseIndex#diff-06c0794a50eeb31f89a201b87d5ca19cR363 https://github.com/geotools/geotools/compare/master...ahuarte47:GEOS-6842_CdxDbaseIndex#diff-a88ff865d43d7e251586c8e2231cbaa1R64 https://github.com/geotools/geotools/compare/master...ahuarte47:GEOS-6842_CdxDbaseIndex#diff-a88ff865d43d7e251586c8e2231cbaa1R120
But if it is desired, it is feasible mix the spatial and atribute indexing. We can add easily the spatial operators to the filter evaluation and call to the current spatial index managers. See:https://github.com/geotools/geotools/compare/master...ahuarte47:GEOS-6842_CdxDbaseIndex#diff-25edc49c37eb0e66e826327792572fdbR59 https://github.com/geotools/geotools/compare/master...ahuarte47:GEOS-6842_CdxDbaseIndex#diff-25edc49c37eb0e66e826327792572fdbR281 uf, I hope I explained properly! I will try to describe all in more detail in the proposal page. Best regardsAlvaro De: A Huarte <ahuart...@yahoo.es> Para: Jody Garnett <jody.garn...@gmail.com> CC: "geotools-devel@lists.sourceforge.net" <geotools-devel@lists.sourceforge.net> Enviado: Sábado 7 de noviembre de 2015 0:00 Asunto: Re: [Geotools-devel] [NEW FEATURE] Implement a pure java Dbase indexing Yes, the code implements a filter evaluator using the keys of an index file to resolve the properties of the filter. Now, It only supports CDX-index files generated with foxpro (Our client uses this format). It is possible write mdx, ndx or idx file managers implementing a new little set of interfaces. These formats are similar and I think feasible implement them (Specification: http://www.clicketyclick.dk/databases/xbase/format/) Unfortunately I dont know about qnx files. About formally propose a new feature, I will use your advices and I will create a wiki page. Best regardsAlvaro NOTE:Sorry, I sent a previous no finished message. De: Jody Garnett <jody.garn...@gmail.com> Para: A Huarte <ahuart...@yahoo.es> CC: "geotools-devel@lists.sourceforge.net" <geotools-devel@lists.sourceforge.net> Enviado: Viernes 6 de noviembre de 2015 23:23 Asunto: Re: [Geotools-devel] [NEW FEATURE] Implement a pure java Dbase indexing So if I understand you, you have an attribute index implementation available that we could use to optimize shapefile access. Can these indexes be used with qnx index (like can we use both at once?). So yeah I like this idea very much, to formally propose a new feature like this we ask people to create a wiki page (see our developers guide for details). There are examples here. --Jody Garnett On 5 November 2015 at 13:06, A Huarte <ahuart...@yahoo.es> wrote: Hi, I would present for review or opinions, a new Dbase index classes-set to speedup alphanumeric queries in shapefiles. https://github.com/geotools/geotools/compare/master...ahuarte47:GEOS-6842_CdxDbaseIndex Now, for no-spatial nor fid-index queries, the shapefile reads all features to evaluate the filter. This behavior is especially problematic in performance with big data sources or complex/heavy querys. The code skips the bruteforce read of the shapefile and for big shapefiles is very fast. Now, it only reads cdx-index files, but It is feasible also write ndx-mdx-idx file managers). These classes are in testing fase, but my organization want to propose it as a new feature of shapefile provider of GeoTools.What do you think? Thak you very much!Alvaro ------------------------------------------------------------------------------ _______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel ------------------------------------------------------------------------------ _______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
------------------------------------------------------------------------------
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
