Hi,
some time ago I've added the ability to force the usage of a spatial index,
now I'm getting requests to add even more hints.
If we factor out the index usage ones, which are index specific, all of the
others are just a comma separate list of static keywords:
http://msdn.microsoft.com/en-US/library/ms187373.aspx
So, this time in order to add those I'd roll a new configuration option for
the store allowing to provide a comma separate list of the desired hints,
which will be transferred verbatim into the select queries.
It could be called "select hints"
Now, obviously it would be interesting to also allow specifying them
on a query by query basis using Query Hints, but:
* it's also good to have global defaults, instead of being forced to specify
them for every query
* the work to do them by query is larger (it would require a counterpart
in the GeoServer GUI to set them up, and the creation of new code
paths in JDBC store to send down these hints)
The store query hint can be a starting point if you want, if we get
resources to do the per query one later, that would be great of course,
but we're not there yet.
Feedback?
Cheers
Andrea
--
==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
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
-------------------------------------------------------
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
