Hi,
here is the pull request to manage the indexes in a JDBC data store:
https://github.com/geotools/geotools/pull/340
I know that originally I only planned to add support for index creation,
but testing was
so much easier also having list and drop available :-p
I've tested the patch with H2, PostGIS, Oracle, SQLServer and Spatialite.
Generally speaking the patch deviates a bit from the current architecture
in that it
delegate the full construction of the create/drop index commands to the
SQLDialect,
as well as running them.
The rationale is that whilst common index handling is pretty uniform among
databases,
if one wants to add support for secondary spatial indexes in the dialects
(something I haven't
done in this patch), well, the behavior is completely all over the place,
the syntax to do so varies a lot among databases,
and you might have to perform inserts and deletes before/after the index
management
commands.
Feedback appreciated
Cheers
Andrea
--
== Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information ==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
