I think that what they are talking about when saying 300 connections Is the
amount of connections at which the server still runs at decent speed,
probably the average work load for 300 users is the recommended amount to
which it can scale to, I don't know if firebird uses the same but interbase
(since the last time I checked) uses blocking sockets which creates a thread
per connection, this roughly scales to around 300, even though the absolute
limit is much higher 1800+, it starts getting really slow if the amount of
threads exceeds the 100ds,
Maybe firebird can run as asynchronous or IOCP which would increase this
amount I suppose significantly, but maybe it was done specifically due to
compatibility issues (other platforms etc), and I think IOCP is a windows
specific thing.

Just my thoughts on things these are general issues for all servers, not an
expert on FB server, etc.

_____

From: Martijn Tonies [mailto:m.tonies@...]
Sent: Tuesday, November 18, 2003 3:52 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] concurrent connection limit

Hi,

> With IB doesn't it work on the number and type of licences you have
> installed ?

If you're not using the "open edition", then yes - it's license dependent.

> Naturally FB has an 'open' license, so this is not an issue, but there

must

> be some theoretical limit.

But - the current hardcoded limit, for both engines, is 1024.

--
Martijn

> Regards
> Rich P...
>
> -----Original Message-----
> From: Martijn Tonies [mailto:m.tonies@...]
> Sent: 18 November 2003 13:06
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] concurrent connection limit
>
>
> Hi,
>
> > Yesterday, a technical contact of Borland Argentina told me that

Interbase

> > support until 300 concurrent clients at the same time.
> >
> > It applies to Firebird 1.5 too?
>
> No, and it doesn't apply to InterBase either.
>
> As far as I remember, the current hard-coded limit is 1024 connections.
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS

SQL

> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>

Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/SIG=12c9i1c20/M=258297.4155332.5363524.4049140/D=egroup
web/S=1705115386:HM/EXP=1069249886/A=1683962/R=0/*http:/www.techsmith.com/rd
r/ban/syah/default.asp> click here


<http://us.adserver.yahoo.com/l?M=258297.4155332.5363524.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=470951569>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


[Non-text portions of this message have been removed]