Solved

paradox

Posted on 2001-08-03
6
675 Views
Last Modified: 2010-04-06

what is the number limitation of incremental field in Paradox ?

How many record can be store on one Table (Paradox) ?, what is the amount of records where things can start be difficult ?

0
Comment
Question by:asi
6 Comments
 
LVL 7

Accepted Solution

by:
Motaz earned 50 total points
ID: 6348130
AutoInc is a 32 bit Integer, so that it is 2 Gega limit, (I don't think that there is a database in the world contains 2 gega records)

I use paradox for 5 Million records and it works fine, except that I have a long delay on retreiving Query select statements results.

Befor creating your table make sure to increase the block size of BDE in the machine that your want to create your Paradox table in to 32 K: Control Panel BDE Admin, Native Drivers, Paradox, block size = 32

This is some limitations in BDE, DBase and Paradox from Borland site:

---------------------------------------

Technical Information Database

TI159B.txt   Some current internal limits of BDE
Category   :BIN
Platform    :All
Product    :BDE  All

Description:

Here are the maximum limits for some common BDE objects. If you find you cannot reach these limits or are getting an out of memory error, increasing your SHAREDMEMSIZE in BDE Config to 4096 or more should allow you to reach these limits.

GENERAL LIMITS

--------------

48     Clients in system

32     Sessions per client (3.5 and earlier, 16 Bit, 32 Bit)

256    Session per client (4.0, 32 Bit)

32     Open databases per session (3.5 and earlier, 16 Bit, 32 Bit)

2048   Open databases per session (4.0, 32 Bit)

32     Loaded drivers

64     Sessions in system (3.5 and earlier, 16 Bit, 32 Bit)

12288  Sessions in system (4.0, 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    Size of SQL statement (RequestLive=False)

4K     Size of SQL statement (RequestLive=True)

6K     Size of SQL statement (RequestLive=True) (4.01, 32 Bit)

16K    Record buffer size (SQL or ODBC)

31     Table and field name size in characters

64     Stored procedure name size in characters

16     Fields in a 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





PARADOX LIMITS

--------------

127    Tables open per system (4.0 and earlier, 16 Bit, 32 Bit)

254    Tables open per system (4.01, 32 Bit)

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 (4.0 and earlier, 16 Bit, 32 Bit)

           (DB, PX, MB, X??, Y??, VAL, TV)

1024   Open physical files (4.01, 32 Bit)

           (DB, PX, MB, X??, Y??, VAL, TV)

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)




DBASE LIMITS

------------

256    Open dBASE tables per system (16 Bit)

350    Open dBASE tables per system (BDE 3.0 - 4.0, 32 Bit)

512    Open dBASE tables per system (BDE 4.01, 32 Bit)

100    Record locks on one dBASE table  (16 and 32 Bit)

100    Records in transactions on a dBASE table (32 Bit)

1      Billion records in a table

2      Billion bytes in .DBF (Table) file

4000   Size in bytes per record (dBASE 4)

32767  Size in bytes per record (dBASE for Windows)

255    Number of fields per table (dBASE 4)

1024   Number of fields per table (dBASE for Windows)

47     Number of index tags per .MDX file

254    Size of character fields

10     Open master indexes (.MDX) per table

220    Key expression length in characters

Reference:


Borland

7/15/98 3:24:20 PM

-----------------

Motaz Abdel Azeem
www.geocities.com/motaz1
0
 

Author Comment

by:asi
ID: 6348216
what is a Client ? Application or Computer ?
0
 
LVL 4

Expert Comment

by:YodaMage
ID: 6348892
Client in Paradox is per connection. So one machine with two apps using seperate connections would basically be two clients.

The question you need to address though, is do you really want to use Paradox? I've done a good deal of work with Paradox, and have seen its' good points as well as its' bad. If you have a small system (under 5 clients), with no security issues and little concern for record locking, and also do not require complicated indices, Paradox is a good choice. If you require some of these things on a small system, you are probably better off going to Access tables. If you are looking to run a larger system with 10+ users, then you might want to look seriously at a true SQL DB like MySQL, or Interbase.

0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:asi
ID: 6352721
the problem with

MySQL, or Interbase

is that there licence policy isn't very clear to me.

when do i need to pay and how much ?
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 6844655
Question(s) below appears to have been abandoned. ADMINISTRATION HAS BEEN ADVISED AND WILL BE CONTACTING YOU SHORTLY.  There are a total of 57 open questions for you, any not shown here have ZERO comments added, so you can delete them directly.

Your options are:
 
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you. You must tell the participants why you wish to do this, and allow for Expert response.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question. Again, please comment to advise the other participants why you wish to do this.

For special handling needs, please post a zero point question in the link below and include the question QID/link(s) that it regards.
http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
 
Please click the Help Desk link on the left for Member Guidelines, Member Agreement and the Question/Answer process.  http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp

Please click you Member Profile to view your question history and keep them all current with updates as the collaboration effort continues, to track all your open and locked questions at this site.  If you are an EE Pro user, use the Power Search option to find them.

To view your open questions, please click the following link(s) and keep them all current with updates.
http://www.experts-exchange.com/questions/Q.11624838.html
http://www.experts-exchange.com/questions/Q.11837819.html
http://www.experts-exchange.com/questions/Q.12000718.html
http://www.experts-exchange.com/questions/Q.20015588.html
http://www.experts-exchange.com/questions/Q.20033766.html
http://www.experts-exchange.com/questions/Q.20060547.html
http://www.experts-exchange.com/questions/Q.20086506.html
http://www.experts-exchange.com/questions/Q.20087146.html
http://www.experts-exchange.com/questions/Q.20096878.html
http://www.experts-exchange.com/questions/Q.20099988.html
http://www.experts-exchange.com/questions/Q.20103524.html
http://www.experts-exchange.com/questions/Q.20105868.html
http://www.experts-exchange.com/questions/Q.20124168.html
http://www.experts-exchange.com/questions/Q.20126164.html
http://www.experts-exchange.com/questions/Q.20126258.html
http://www.experts-exchange.com/questions/Q.20127406.html
http://www.experts-exchange.com/questions/Q.11610958.html
http://www.experts-exchange.com/questions/Q.20136024.html
http://www.experts-exchange.com/questions/Q.20137249.html
http://www.experts-exchange.com/questions/Q.20147343.html
http://www.experts-exchange.com/questions/Q.20162739.html
http://www.experts-exchange.com/questions/Q.20163581.html
http://www.experts-exchange.com/questions/Q.20165158.html
http://www.experts-exchange.com/questions/Q.20167166.html
http://www.experts-exchange.com/questions/Q.20177854.html
http://www.experts-exchange.com/questions/Q.20185774.html
http://www.experts-exchange.com/questions/Q.20185782.html
http://www.experts-exchange.com/questions/Q.20211426.html
http://www.experts-exchange.com/questions/Q.20211827.html
http://www.experts-exchange.com/questions/Q.20229407.html
http://www.experts-exchange.com/questions/Q.20231198.html
http://www.experts-exchange.com/questions/Q.20238567.html
http://www.experts-exchange.com/questions/Q.20238568.html
http://www.experts-exchange.com/questions/Q.20238571.html
http://www.experts-exchange.com/questions/Q.20240061.html
http://www.experts-exchange.com/questions/Q.20241871.html
http://www.experts-exchange.com/questions/Q.20242268.html
http://www.experts-exchange.com/questions/Q.20244256.html
http://www.experts-exchange.com/questions/Q.20246106.html
http://www.experts-exchange.com/questions/Q.20250445.html
http://www.experts-exchange.com/questions/Q.20251868.html
http://www.experts-exchange.com/questions/Q.20254886.html
http://www.experts-exchange.com/questions/Q.20254704.html
http://www.experts-exchange.com/questions/Q.20255422.html
http://www.experts-exchange.com/questions/Q.20261740.html
http://www.experts-exchange.com/questions/Q.20262552.html
http://www.experts-exchange.com/questions/Q.20262985.html
http://www.experts-exchange.com/questions/Q.20265275.html
http://www.experts-exchange.com/questions/Q.20270259.html
http://www.experts-exchange.com/questions/Q.20270694.html
http://www.experts-exchange.com/questions/Q.20270687.html
http://www.experts-exchange.com/questions/Q.20271885.html


To view your locked questions, please click the following link(s) and evaluate the proposed answer.
http://www.experts-exchange.com/questions/Q.20171579.html
http://www.experts-exchange.com/questions/Q.20178687.html
http://www.experts-exchange.com/questions/Q.20265222.html
http://www.experts-exchange.com/questions/Q.20265219.html
http://www.experts-exchange.com/questions/Q.20269116.html

PLEASE DO NOT AWARD THE POINTS TO ME.  
 
------------>  EXPERTS:  Please leave any comments regarding your closing recommendations if this item remains inactive another seven (7) days.
 
Thank you everyone.
 
Moondancer
Moderator @ Experts Exchange

P.S.  For any year 2000 questions, special attention is needed to ensure the first correct response is awarded, since they are not in the comment date order, but rather in Member ID order.
0
 
LVL 5

Expert Comment

by:Netminder
ID: 6887770
Admin notified of User neglect. Force-accepted by
Netminder
Community Support Moderator
Experts Exchange
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
proper way to parse url in delphi 2 192
delphi prevent click fast 2 212
delphi exception 7 64
Delphi...Split view - idea? 1 67
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now