That seems fine, but we may wish to police the hints we accept and pass
along. Not sure how open this one is to SQL injection.
Do other database use this approach?
Jody Garnett
On Fri, May 16, 2014 at 11:07 AM, Andrea Aime
<[email protected]>wrote:
> 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
>
>
------------------------------------------------------------------------------
"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
