_______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message. _______________________________________________________________________________________ Thanks Andrea! Unfortunately, we're light on developers at our level of the business. Commercial support isn't put of the question, but the pragmatic approach would be to setup some SQL Server packages to export data to Postgres when the data's updated. It'll run faster there anyway! ;-) Regards, --------------------------------------------- HUGH SAALMANS GIS DEVELOPMENT MANAGER - GEOSPATIAL INFORMATION NATIONAL TECHNICAL PRICING T +61 (0)2 9292 3351 F +61 (0)2 9292 1120 E [email protected] PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL. --------------------------------------------- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andrea Aime Sent: Friday, 26 October 2012 9:50 PM To: Hugh Saalmans Cc: [email protected] Subject: Re: [Geoserver-users] Spatial Index not being Used in SQL Server Layer On Fri, Oct 26, 2012 at 2:46 AM, Hugh Saalmans <[email protected]> wrote: > So, assuming Microsoft aren't going to improve the way spatial indexes are > activated by queries: what's the status of Geoserver supporting SQL Server > spatial index hints when requesting the data? And does anyone have a > workaround, noting the comment above... There is no support for hints, and we'd have to modify the general JDBC handling code (which is based on a shared core + dialects per spatial database) to add support for hints. It's doable, but requires some work. Do you have your own Java developers? If so I can point you at the classes that might have to be modified. Otherwise you can look into commercial support and have someone do the work for you: http://geoserver.org/display/GEOS/Commercial+Support 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 ------------------------------------------------------- _______________________________________________________________________________________ The information transmitted in this message and its attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information, by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files, with the permission of the sender. This message has been scanned for viruses. _______________________________________________________________________________________ ------------------------------------------------------------------------------ WINDOWS 8 is here. Millions of people. Your app in 30 days. Visit The Windows 8 Center at Sourceforge for all your go to resources. http://windows8center.sourceforge.net/ join-generation-app-and-make-money-coding-fast/ _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
