Re: [dbcp] Optimal defaults for DSpace

2021-01-12 Thread Hrafn Malmquist
Hey Phil Thanks for responding. So, in your opinion, maxWaitMillis is optimally configured at 5 seconds as opposed to the default indefinite? Thanks for your input again and pointing to those resources. I think clearly I need to spend more time researching this. On Fri, Jan 1, 2021 at

Re: [dbcp] Optimal defaults for DSpace

2021-01-01 Thread Phil Steitz
On 12/20/20 10:26 PM, Hrafn Malmquist wrote: Hi Gary Thanks for taking the time to respond. I hope you can bear with me as I am still learning about database connection pooling. Perhaps I did not ask the question correctly. I am not asking about a site specific setup but rather what

Re: [dbcp] Optimal defaults for DSpace

2021-01-01 Thread Hrafn Malmquist
>> Hi Gary >> >> I have and they don't know. Therefore, we are kind of looking at this >> afresh. >> >> For a web server like this, where there are usually lots of reads and not >> many writes. >> > >DBCP is agnostic to reading vs. writing, that all happens in SQL as I am >sure you know ;-) When

Re: [dbcp] Optimal defaults for DSpace

2020-12-31 Thread Gary Gregory
On Thu, Dec 31, 2020 at 11:55 AM Hrafn Malmquist wrote: > Hi Gary > > I have and they don't know. Therefore, we are kind of looking at this > afresh. > > For a web server like this, where there are usually lots of reads and not > many writes. > DBCP is agnostic to reading vs. writing, that all

Re: [dbcp] Optimal defaults for DSpace

2020-12-31 Thread Hrafn Malmquist
Hi Gary I have and they don't know. Therefore, we are kind of looking at this afresh. For a web server like this, where there are usually lots of reads and not many writes. Does having defaults: maxWaitMillis = 5000, maxIdle = 10, maxTotal = 30 Make more sense than the DCP2 defaults?

Re: [dbcp] Optimal defaults for DSpace

2020-12-29 Thread Gary Gregory
Hi, I think you will have to ask the Dspace committers why they chose those specific values. Gary On Mon, Dec 21, 2020, 00:27 Hrafn Malmquist wrote: > Hi Gary > > Thanks for taking the time to respond. > > I hope you can bear with me as I am still learning about database > connection pooling.

Re: [dbcp] Optimal defaults for DSpace

2020-12-20 Thread Hrafn Malmquist
Hi Gary Thanks for taking the time to respond. I hope you can bear with me as I am still learning about database connection pooling. Perhaps I did not ask the question correctly. I am not asking about a site specific setup but rather what defaults should be shipped with the software. I am part

Re: [dbcp] Optimal defaults for DSpace

2020-12-20 Thread Gary Gregory
Hi, Each new DBCP release brings fixes, additions, and other updates, as you can read in the release notes. How to best configure DBCP for any given combination of JDBC driver, its database, and application will be quite variable, which is somewhat out of scope here IMO. Gary On Fri, Dec 18,

[dbcp] Optimal defaults for DSpace

2020-12-18 Thread Hrafn Malmquist
Good day I'm wondering what are optimal defaults for DSpace, open source digital repository software aimed especially at academic, non-profit, and commercial organizations (see https://duraspace.org/dspace/). DSpace supports both Postgres and Oracle and recommends Tomcat, Jetty or Caucho Resin.