not sure on the max...

right at this moment on our busiest server we have approx. 120
connections over port 3050 and 60 connections over port 3060 -- so not
quite in your expected range of 500-1000 concurrent connections...

-steve

hi_feroz wrote:

> hi steve,
> thanks for the info.
> what is the max. no. of concurrent connections so far that you have
> noticed in your environment?
>
> -feroz
>
>
> --- In firebird-support@yahoogroups.com, Steve Wiser <steve@...>
> wrote:
>
>> We have a 4 way CPU server with 8 GB of RAM as well running
>>
> Classic.
>
>> The only advice I have is to us the HugeMem kernel (well at least
>>
> use it
>
>> if you are running CentOS which you are not) and to make sure to
>>
> set the
>
>> xinetd configurations to allow unlimited connections and not to
>>
> throttle
>
>> the connections.
>>
>> -steve
>>
>> hi_feroz wrote:
>>
>>> hi all,
>>> i would need some advice on this. i have got FB CS 1.5.3 running
>>>
> in
>
>>> Mandrake 10.1 (thanks for helen). the production is mandriva
>>>
> 2006.
>
>>> i have been running Client/Server Application using:
>>> 1) FB SS 1.5.2
>>> 2) Windows 2000 Server, 2 x 2.4GHtz Processors, 4GD RAM
>>> 3) On average 50 Concurrent Client Connection
>>> 5) During Peak period (once in every 3 months) 85 Concurrent
>>> Connection.
>>> 6) One point to note here is that, i have set the affinity of FB
>>>
> SS
>
>>> to use 1 processor (as it was giving problems using SMP)
>>>
>>> i have not had many problems. my database size is less than
>>>
> 100MB.
>
>>> most widely used table has less that 120,000 records with 30
>>>
> fields.
>
>>> other frequent tables have 50,000 to 70,000 records.
>>>
>>> Now, one of the modules of the application has been upgared to
>>>
> web-
>
>>> based. I am using EJB3, JBoss 4.0.4CR2.
>>>
>>> the configuration of the new machine is:
>>> 1) 4 x 3.0 GHtz MT Processors (64 bit)
>>> 2) 8GB RAM
>>> 3) 4 x SCSI H/D
>>> 4) Mandriva 2006 (64 bit)
>>>
>>> i have done some reading that it is better to use FB (Classic
>>> Server) on SMP's if there is enough RAM (this system has 8GB
>>>
> RAM).
>
>>> The version i am using is FirebirdCS-1.5.3.4870.i686.The No. of
>>> concurrent connections may grow between 500 - 1000. The exact
>>>
> no's,
>
>>> i can know only in June when system will be used.
>>>
>>> i was hoping to get some advice from you guys as what areas
>>>
> shoudl i
>
>>> look into, like configuration, etc.
>>>
>>> thanks!
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>>> Visit http://firebird.sourceforge.net and click the Resources
>>>
> item
>
>>> on the main (top) menu. Try Knowledgebase and FAQ links !
>>>
>>> Also search the knowledgebases at http://www.ibphoenix.com
>>>
>>>
>>>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>>>
>>> Yahoo! Groups Links
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>
>
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>