Board index » delphi » max number of active IBTable per TIBDatabase Component

max number of active IBTable per TIBDatabase Component


2005-12-19 03:50:32 PM
delphi119
Hi there,
I am using C++ builder 6 and Interbase 6.5.
I want to know, what is the maximum number of active IBTable component can
exists per IBdatabase component.
Is there is any limit on this active IBTable component per IBDatabase.
for example,
IBTable1->Database = IBDatabase1; // this is first IBTable for IBDatabase;
IBTable1->TableName = "temp";
IBTable1->Transaction = IBTransaction1;
IBTable1->Active = true;
IBTable2->Database = IBDatabase2; // this is second IBTable for IBDatabase;
IBTable2->TableName = "temp";
IBTable2->Transaction = IBTransaction2;
IBTable2->Active = true;
IBTable3->Database = IBDatabase3; // this is third IBTable for IBDatabase;
IBTable3->TableName = "temp";
IBTable3->Transaction = IBTransaction3;
IBTable3->Active = true;
and so on...........
Thanks,
viv....
 
 

Re:max number of active IBTable per TIBDatabase Component

Each user is allowed (asuming a non desktop version of Interbase) 4
connections. So if you have 10 licenses you could make 40 database
attachements for one application and none for the rest. On the other
hand you could make one app that uses 4 database attachments and run
the app on 10 machines.
Connections are limited by licenses. IIRC the upper limit is 1024, but
I might be wrong on that one.
--
Rob Schieck
TeamB
 

Re:max number of active IBTable per TIBDatabase Component

viv writes:
Quote

I want to know, what is the maximum number of active IBTable
component can exists per IBdatabase component.
You are really only limited by memory here, I am not aware of any artificial
limit.
The bigger issue is that you are using TIBTable. This component is really
only there to ease migration from older applications (e.g. those using the
BDE and TTable). For new development you should avoid TIBTable like the
plague and use TIBQuery, TIBDataset, and TIBSQL instead.
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: www.logicfundamentals.com/RADBooks.html
"Nurture your mind with great thoughts. To believe in the heroic makes
heroes." ?Benjamin Disraeli