Subject | Re: [firebird-support] limits of the firebird |
---|---|
Author | Martijn Tonies |
Post date | 2009-10-09T11:49:27Z |
Hi,
Is the middle tier creating 5000 database connections as well? Or does it
use some kind of connection poolling mechanism?
What kind of activity do you expect?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
> Scenario will be approximately 5000 simultaneous connections, in anHard to tell without knowing what these connections are doing.
> n-tier application developed in Delphi 2010, I need to know what is the
> minimum configuration for the firebird support without loss of
> performance.
Is the middle tier creating 5000 database connections as well? Or does it
use some kind of connection poolling mechanism?
What kind of activity do you expect?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
> Alexandre Benson Smith escreveu:
>>
>>
>> Vinicius wrote:
>> > a machine with 10 processors which would be the approximate limits
>> >
>>
>> 10 CPU's and ????
>> 16KB of RAM ?
>> 20MB MFM disk using stacker ?
>> 10mbits coaxial cable link ?
>> Runing on MS-DOS 3.1 ?
>>
>> To support wich kind of query ?
>> select * from VeryBigTableWithoutIndices order by VeryBigVarCharColumn1,
>> VeryBigVarCharColumn2, VeryBigVarCharColumn3
>>
>> It's impossible to answer your question if you don't provide *much* more
>> information...
>>
>> Why don't you describe your expected scenario ?
>>
>> see you !