?
Solved

paradox

Posted on 2001-08-03
6
Medium Priority
?
683 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 200 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses
Course of the Month17 days, 8 hours left to enroll

829 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