Re: [PERFORM] increasing database connections

2007-03-01 Thread Joshua D. Drake
Magnus Hagander wrote: > On Thu, Mar 01, 2007 at 12:49:14AM -0500, Jonah H. Harris wrote: >> On 3/1/07, Shiva Sarna <[EMAIL PROTECTED]> wrote: >>> I am sorry if it is a repeat question but I want to know if database >>> performance will decrease if I increase the max-connections to 2000. At >>> pre

Re: [PERFORM] increasing database connections

2007-03-01 Thread Ron
At 01:18 AM 3/1/2007, Joshua D. Drake wrote: Jonah H. Harris wrote: > On 3/1/07, Shiva Sarna <[EMAIL PROTECTED]> wrote: >> I am sorry if it is a repeat question but I want to know if database >> performance will decrease if I increase the max-connections to 2000. At >> present it is 100. > > Most

Re: [PERFORM] increasing database connections

2007-03-01 Thread Florian Weimer
* Mark Kirkwood: > Yeah - I thought that somewhere closer to 1 connections is where > you get hit with socket management related performance issues. Huh? These sockets aren't handled in a single process, are they? Nowadays, this number of sockets does not pose any problem for most systems, e

Re: [PERFORM] increasing database connections

2007-03-01 Thread Magnus Hagander
On Thu, Mar 01, 2007 at 12:49:14AM -0500, Jonah H. Harris wrote: > On 3/1/07, Shiva Sarna <[EMAIL PROTECTED]> wrote: > >I am sorry if it is a repeat question but I want to know if database > >performance will decrease if I increase the max-connections to 2000. At > >present it is 100. > > Most cer

Re: [PERFORM] increasing database connections

2007-02-28 Thread Mark Kirkwood
Joshua D. Drake wrote: Jonah H. Harris wrote: On 3/1/07, Shiva Sarna <[EMAIL PROTECTED]> wrote: I am sorry if it is a repeat question but I want to know if database performance will decrease if I increase the max-connections to 2000. At present it is 100. Most certainly. Adding connections ov

Re: [PERFORM] increasing database connections

2007-02-28 Thread Joshua D. Drake
Jonah H. Harris wrote: > On 3/1/07, Shiva Sarna <[EMAIL PROTECTED]> wrote: >> I am sorry if it is a repeat question but I want to know if database >> performance will decrease if I increase the max-connections to 2000. At >> present it is 100. > > Most certainly. Adding connections over 200 will

Re: [PERFORM] increasing database connections

2007-02-28 Thread Jonah H. Harris
On 3/1/07, Shiva Sarna <[EMAIL PROTECTED]> wrote: I am sorry if it is a repeat question but I want to know if database performance will decrease if I increase the max-connections to 2000. At present it is 100. Most certainly. Adding connections over 200 will degrade performance dramatically.

[PERFORM] increasing database connections

2007-02-28 Thread Shiva Sarna
Hi, I am sorry if it is a repeat question but I want to know if database performance will decrease if I increase the max-connections to 2000. At present it is 100. I have a requirement where the clent want 2000 simultaneous users and the only option we have now is to in crease the database con