Paradox Community
Search:

 Welcome |  What is Paradox |  Paradox Folk |  Paradox Solutions |
 Interactive Paradox |  Paradox Programming |  Internet/Intranet Development |
 Support Options |  Classified Ads |  Wish List |  Submissions 


Paradox Newsgroups  |  Paradox Web Sites  |  Paradox Book List  |  FAQs From The Corel FAQ Newsgroup  



Subject: FAQ:PdoxWin:Paradox & BDE Limitations:2002.07.18

Version 1.0 (2000.09.22)
edited by Mike Irwin
Repost by Mike Irwin: 2001.02.05
Version 1.1 (2001.05.25)
edited by Mike Irwin: 2001.05.25
Repost by Mike Irwin: 2001.02.05
Version 1.2 (2002.07.18)

====================
0. Introduction
====================

This FAQ states the published limitations to Paradox's
functionality, grouping current knowledge. If you have
items that should be added, please contact the author.

-------------------------------
 0.1 Legal Info and Disclaimers
-------------------------------

Paradox is a trademark of Corel.
Borland Database Engine (BDE) is a trademark of Inprise.

The information provided in this FAQ is provided "as is"
and is not warranted in any way. The information provided
in this FAQ is not endorsed or authorized by Corel or
Inprise in any shape, form, or manner. The editors claim
NO responsibility for ANY illegal activity regarding this
file, or as a result of someone reading this file.

You may distribute this file, as long as the copies are
complete, unaltered, and are in electronic form only.

-------------
 0.2 Feedback
-------------

Please send feedback in a Corel Paradox newsgroup or the
news:comp.databases.Paradox newsgroup to any of the FAQ
Team mentioned in the "FAQ: FAQ FAQ" document.
Please preface the subject of your post with the string
"PDXWIN FAQ" to alert Team members to the function of
the message.
Please specify the FAQ name and section number the
comment applies to, if any.

==============================
1. General
==============================

These are current as of version 9 from Corel. You can
also investigate this subject at

http://www.borland.com/devsupport/bde/ti_list/TI2751.html

========
2. General BDE Limitations
========

48          Clients in system
32          Sessions per client
                (3.5 and earlier, 16 Bit, 32 Bit)
256         Sessions per client
                (4.0 & later, 32 Bit)
64          Sessions with a cursor open per client
                (4.0 & later, 32 Bit)
32          Open databases per session
                (3.5 and earlier, 16 Bit, 32 Bit)
2048        Open databases per session
                (4.0 & later, 32 Bit)
32          Loaded drivers
64          Sessions in system
                (3.5 and earlier, 16 Bit, 32 Bit)
12288       Sessions in system
                (4.0 & later, 32 Bit)
4000        Cursors per session
16          Entries in error stack
8           Table types per driver
16          Field types per driver
8           Index types per driver
48K         Size of configuration (IDAPI.CFG) file
64K         Max size of SQL statement (RequestLive=False)
4K          Max size of SQL statement (RequestLive=True)
6K          Max size of SQL statement (RequestLive=True)
                (BDE 4.01&later)
16K         Record buffer size (SQL and ODBC)

31          Table and field name size in characters
64          Stored procedure name size in characters
16          Fields in key
3           File extension size in characters
260         Table name length in characters
                (some servers might have other limits)
260         Path and file name length in characters
260         Index name length (including pseudo-indexes)
204         Setting for MEMSIZE in BDE Administrator
127         Tables with cached updates applied
                (BDE 4.0 & earlier, 32 Bit)
254         Tables with cached updates applied
                (BDE 4.01 & later, 32 Bit)
380         Maximum number of fields in Table for
                DbiCreateTable with Interbase
254         Maximum number of fields in Table for
                DbiCreateTable with Oracle
500         Maximum number of fields in Table for
                DbiCreateTable with Informix
252         Maximum number of fields in Table for
                DbiCreateTable with MSSQL
250         Maximum number of fields in Table for
                DbiCreateTable with ODBC, Sybase
253         Maximum number of fields in Table for
                DbiCreateTable with DB2
408         Maximum number of fields used in an Interbase
                Table
1000000     Maximum number of bytes per blob for ODBC

========
2. Paradox Limitations
========

127         Tables open per system
254         Tables open per system (BDE 4.01 & later)
64          Record locks on one table (16Bit) per session
255         Record locks on one table (32Bit) per session
255         Records in transactions on a table (32 Bit)
512         Open physical files
                      (DB, PX, MB, X??, Y??, VAL, TV)
1024        Open physical files
                      (DB, PX, MB, X??, Y??, VAL, TV)
                      (BDE 4.01 & later)
300         Users in one PDOXUSRS.NET file
255         Number of fields per table
255         Size of character fields
2           Billion records in a table
2           Billion bytes in .DB (Table) file
10800       Bytes per record for indexed tables
32750       Bytes per record for non-indexed tables
127         Number of secondary indexes per table
16          Number of fields in an index
255         Concurrent users per table
256         Megabytes of data per BLOb field
100         Passwords per session
15          Password length
63          Passwords per table
159         Fields with validity checks (32 Bit)
63          Fields with validity checks (16 Bit)
81          Maximum characters in path for tables
                     involved in Referential Integrity
25          Field name size in characters
2500        Max. number of entries in a list.
                This impacts drop-lists (combo-boxes).

Notes on Paradox Table Types

When referring to Paradox Table Types, the type number,
or"Level", is taken from the version of Paradox with
which itwas introduced.

To move a table's level to a higher level, arrange to
include some feature that requires the use of the higher
level.


Paradox Community Newsgroups


 Feedback |  Paradox Day |  Who Uses Paradox |  I Use Paradox |  Downloads 


 The information provided on this Web site is not in any way sponsored or endorsed by Corel Corporation.
 Paradox is a registered trademark of Corel Corporation.


 Modified: 15 May 2003
 Terms of Use / Legal Disclaimer


 Copyright © 2001- 2003 Paradox Community. All rights reserved. 
 Company and product names are trademarks or registered trademarks of their respective companies. 
 Authors hold the copyrights to their own works. Please contact the author of any article for details.