Questions About BDE Limitations

Al Willis

Delphi Developer

Mon, 28 May 2001 03:00:00 GMT

Questions About BDE Limitations

In BDE document TI2751 under the General BDE Limitations, the BDE is said to
have a limit of 48 clients. Under the Paradox Limitations section, it
states that there is a maximum of 300 users in PDOXUSRS.NET. If I'm running
under a Novell or Windows NT Server network, where each user has the BDE
properly installed on their computer, how many users can simultaneously run
a Delphi/BDE/Paradox based application? Is the answer 48 or 300?

What does "254 Tables Open Per System" mean? What is a "System" defined as?

Thanks,

Al Willis
Technical Design Services

Paul Bartlet

Delphi Developer

Tue, 29 May 2001 03:00:00 GMT

Re:Questions About BDE Limitations

You should be able to run 300 users.

You can run 48 BDE applications on one computer.

Yopu can have 254 paradox tables opened on one computer.

Paul Bartlett
pa...@drs.co.uk

Quote

Al Willis wrote in message <74pr91$f1...@forums.borland.com>...
>In BDE document TI2751 under the General BDE Limitations, the BDE is said
to
>have a limit of 48 clients. Under the Paradox Limitations section, it
>states that there is a maximum of 300 users in PDOXUSRS.NET. If I'm
running
>under a Novell or Windows NT Server network, where each user has the BDE
>properly installed on their computer, how many users can simultaneously run
>a Delphi/BDE/Paradox based application? Is the answer 48 or 300?

>What does "254 Tables Open Per System" mean? What is a "System" defined
as?

>Thanks,

>Al Willis
>Technical Design Services

Brian Bushay Tea

Delphi Developer

Wed, 30 May 2001 03:00:00 GMT

Re:Questions About BDE Limitations

Quote

>n BDE document TI2751 under the General BDE Limitations, the BDE is said to
>have a limit of 48 clients. Under the Paradox Limitations section, it
>states that there is a maximum of 300 users in PDOXUSRS.NET. If I'm running
>under a Novell or Windows NT Server network, where each user has the BDE
>properly installed on their computer, how many users can simultaneously run
>a Delphi/BDE/Paradox based application? Is the answer 48 or 300?

>What does "254 Tables Open Per System" mean? What is a "System" defined as?

A system is a single computer. On the single computer you can have 48
connections to BDE. Like 48 different applications all running on the same
computer.
You can have 300 different computers connected to a .net file before it runs out
of connections space. However I do not advise planning an application for 300
users. Perormance problems will catch up with you before you get to 300 users.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Jan Sprenge

Delphi Developer

Wed, 30 May 2001 03:00:00 GMT

Re:Questions About BDE Limitations

On Sat, 12 Dec 1998 05:47:57 GMT, BBus...@Nmpls.com (Brian Bushay

Quote

TeamB) wrote:
>A system is a single computer. On the single computer you can have 48
>connections to BDE. Like 48 different applications all running on the same
>computer.

Brian,

Would an application using 5 sessions count as 1 or as 5 connections?

Jan

Brian Bushay Tea

Delphi Developer

Wed, 30 May 2001 03:00:00 GMT

Re:Questions About BDE Limitations

Quote

>Would an application using 5 sessions count as 1 or as 5 connections?

One connections

These will be some of the limits that apply

48 Clients in system
32 Sessions per client (3.5 and earlier, 16 Bit, 32 Bit)
256 Session per client (4.0, 32 Bit)
64 Sessions in system (3.5 and earlier, 16 Bit, 32 Bit)
12288 Sessions in system (4.0, 32 Bit)
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Al Willi

Delphi Developer

Sat, 16 Jun 2001 03:00:00 GMT

Re:Questions About BDE Limitations

Brian,

Do you have any idea as to when system performance will start to degrade
because of the number of users? I realize that this will vary greatly
depending on the application and hardware.

Thanks,

Al Willis
Technical Design Services

Quote

Brian Bushay TeamB wrote in message <3672e8d8.52130557@floyd>...

>>n BDE document TI2751 under the General BDE Limitations, the BDE is said
to
>>have a limit of 48 clients. Under the Paradox Limitations section, it
>>states that there is a maximum of 300 users in PDOXUSRS.NET. If I'm
running
>>under a Novell or Windows NT Server network, where each user has the BDE
>>properly installed on their computer, how many users can simultaneously
run
>>a Delphi/BDE/Paradox based application? Is the answer 48 or 300?

>>What does "254 Tables Open Per System" mean? What is a "System" defined
as?

>A system is a single computer. On the single computer you can have 48
>connections to BDE. Like 48 different applications all running on the same
>computer.
>You can have 300 different computers connected to a .net file before it
runs out
>of connections space. However I do not advise planning an application for
300
>users. Perormance problems will catch up with you before you get to 300
users.

>--
>Brian Bushay (TeamB)
>Bbus...@NMPLS.com

Brian Bushay Tea

Delphi Developer

Sun, 17 Jun 2001 03:00:00 GMT

Re:Questions About BDE Limitations

Quote

>Do you have any idea as to when system performance will start to degrade
>because of the number of users? I realize that this will vary greatly
>depending on the application and hardware.

The factors that are primarally responsible for perfomance are how much querying
the application does and after that how much editing. If you have an
application that does primaraly querying and reporting you may have trouble with
as few as 10 simaltanious users. If your application is primarly for viewing
data with light editing you probably can get to around 50 simaltanious users

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Stephen Eyton-Jon

Delphi Developer

Wed, 20 Jun 2001 03:00:00 GMT

Re:Questions About BDE Limitations

I have an application which does not use Paradox, however I do have
cached updates and from what I understand that uses Paradox tables.
So, does that mean that I can expect performance problems with 300
users using SQL, Oracle, or Sybase backend?
What is the limit then with C/S databases, Delphi and BDE?

Quote

>A system is a single computer. On the single computer you can have 48
>connections to BDE. Like 48 different applications all running on the same
>computer.
>You can have 300 different computers connected to a .net file before it runs out
>of connections space. However I do not advise planning an application for 300
>users. Perormance problems will catch up with you before you get to 300 users.

>--
>Brian Bushay (TeamB)
>Bbus...@NMPLS.com

Brian Bushay Tea

Delphi Developer

Thu, 21 Jun 2001 03:00:00 GMT

Re:Questions About BDE Limitations

Quote

>I have an application which does not use Paradox, however I do have
>cached updates and from what I understand that uses Paradox tables.
>So, does that mean that I can expect performance problems with 300
>users using SQL, Oracle, or Sybase backend?

No. The table used for the cache will be used only by a single user

Quote

>What is the limit then with C/S databases, Delphi and BDE?

what ever the limitations of your Client server are.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. (D5) TTreeView Nodes QTY limitation / memory limitation

2. BLOB size limitations in BDE?

3. BLOB size limitations in BDE?

4. What are the BDE's limitations?

5. SQL Limitation in BDE Delphi 1.0

6. BDE/Oracle bug/limitation ???

7. BDE-32 error / limitation

8. BDE BLOB size limitations?

9. BLOB size limitations in BDE?

10. BDE-32 error / limitation