On Wed, Oct 9, 2013 at 10:39 PM, osullivj <[email protected]>wrote:

> 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?
>

A shapefile for 80000 points is going to be just fine

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

-------------------------------------------------------
------------------------------------------------------------------------------
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

Reply via email to