Andrea Many thanks for the reply. It looks like we might be going to upgrade to SQL Server in the near future so we can use that source directly.
However we need an interim solution to get the web mapping app running in the short term (6 months) What do you think of having a scheduled task to run an ogr2ogr command line to pull out the data from the website into a shp file every x hours? I am aware the .shp isn't recommended for production environments. As it is only point data (@80,000 records) that needs to displayed and we will look at caching the tiles for a few hours to improve performance would it be ok for a few months? Grateful for any advice you can give Thanks, Jerry -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Point-Data-in-X-Y-Fields-in-RDBMS-tp5082553p5082713.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
