Maximal length of user attribute (first-, middle- and lastname) can not exceed
32 OCTETS (rather than CHARACTERS) on FB-3, 31 octets on FB 2.5
--
21.01.2016 16:45, Mark Rotteveel wrote:
> That doesn't really answer the why :)
Firebird uses only one thread for receiving network packets and the limit is
related to
select()/WSASelect() function that operate with fixed size array of socket
handles.
--
WBR, SD.
Hello!
Thursday, January 21, 2016, 6:06:06 PM, you wrote:
l> may i ask what is the reason of that limit on windows?
that type of interest is suspicious. Currently, huge companies works
in client-server mode with 500-700 simultaneous connections, without
any problem.
When someone asks about 2000
> That doesn't really answer the why :)
>>It does if you google FD_SETSIZE and winsock
>>https://msdn.microsoft.com/en-us/library/windows/desktop/ms739169%28v=vs.85%29.aspx
>>Paul
Hi,
i read this but i still do not know the reason. Is this declared by Firebird
in code.
Because i read in this
21.01.2016 18:20, Leyne, Sean wrote:
> Operationally, your app will die/fail which you try to exceed the Windows
> FD_Size value -- it is a OS level limit.
Nope, it is truly set at compile time and only application-defined
structures are used
by OS.
Problem is not a size of structure
On 1/21/2016 12:41 PM, Dimitry Sibiryakov wrote:
> 21.01.2016 18:20, Leyne, Sean wrote:
>> Operationally, your app will die/fail which you try to exceed the Windows
>> FD_Size value -- it is a OS level limit.
> Nope, it is truly set at compile time and only application-defined
> structures
> Microsoft is now supporting the Linux poll() as WSAPoll(). Much more
> intelligent data structures and is smart enough to wake up when the remote
> end of a socket is closed. I don't know what platforms do or don't support
> poll()
Client OS == Windows Vista+
Server OS == Windows 2008+
>> may i ask what is the reason of that limit on windows?
>
> http://tracker.firebirdsql.org/browse/CORE-4439
> That doesn't really answer the why :)
It does if you google FD_SETSIZE and winsock
https://msdn.microsoft.com/en-us/library/windows/desktop/ms739169%28v=vs.85%29.aspx
Paul
> i read this but i still do not know the reason. Is this declared by Firebird
> in code.
> Because i read in this article that there is no limit in Winsock at all.
> Only constant FD_SETSIZE at compilation time which can by changed in code.
> But maybe i can understand this incorrectly
Hi,
..
>>But anyway, even ~1000 client-server connections are VERY huge number,
>>that needs special hardware infrastructure to implement that. So, this
>>is not only about "firebird limits".
i have now near 400 connections and do not see any problems with resources
or server response.
But
On Thu, Jan 21, 2016 at 01:20:02PM -0500, Jim Starkey wrote:
> On 1/21/2016 12:41 PM, Dimitry Sibiryakov wrote:
> > 21.01.2016 18:20, Leyne, Sean wrote:
> >> Operationally, your app will die/fail which you try to exceed the
> >> Windows FD_Size value -- it is a OS level limit.
> > Nope, it is
Config parameter 'DeadlockTimeout ': mystic affect of its PARITY / ODDNESS on
DDL results
--
Key: CORE-5080
URL: http://tracker.firebirdsql.org/browse/CORE-5080
12 matches
Mail list logo
