GeoServer just accesses connections in the pool with standard JDBC
interface. Its all up to your use cases as to how you configure your pools.
We typically think of a single pool per database. Since you can handle
scaling by configuring your pool. Another way to do it might be per
application. But it does not generally matter how many layers use a single
store. There might be some exceptions to that but haven't run into issues
serving several millions of GetMap requests per day with a single server.
Jason Newmoyer
Newmoyer Geospatial Solutions
843.606.0424
ja...@newmoyergeospatial.com
On Tue, Apr 17, 2018 at 9:20 AM, Robertafoster8 <b...@fostercomputer.net>
wrote:
> Hi
>
> I have hundreds of layers that use the same oracle JNDI. Do I create a
> datastore for each layer, or do I create 1 datastore and use that for each
> layer? Since the connection is managed (pooling, etc) by the oracle
> server,
> what does geoserver do with the datastore?
>
> If I create 1 datastore and use that for all layers, will there be any
> threading issues or performance issues with multiple users requesting maps
> or using WFS services?
>
> Bob
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-
> f3786390.html
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines: http://geoserver.org/comm/
> userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-
> requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
