Do you have meta tiling turned on? I can't see that the DB access is the
bottle neck (though with Oracle anything is possible) - I would have the
lower levels cache on request so that at least popular areas become faster
- unless you are very short fo disk space
Ian
On Tue, Jun 30, 2015 at 3:33 PM gavin.montgomery <[email protected]>
wrote:
> Thank you both, yes ultimately we would like to move to postGIS too,
> however
> slightly constrained by client requirements.
>
> We have been advised to increase the tile size of the requests to improve
> DB
> query performance. I am happy to implement this change but do not believe
> it
> is going to have a substantial impact on the performance when we scale up
> the numbers - maybe allow for another 100 users or so...
>
> FYI we currently have approx 50-60 users concurrent, this will be going up
> significantly in coming weeks and we know the oracle DB will start to run
> hot with that many requests.
>
> Gavin
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/OS-Mastermap-in-Production-1000-s-of-users-tp5213560p5213619.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Don't Limit Your Business. Reach for the Cloud.
> GigeNET's Cloud Solutions provide you with the tools and support that
> you need to offload your IT needs and focus on growing your business.
> Configured For All Businesses. Start Your Cloud Today.
> https://www.gigenetcloud.com/
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users