Solved

Paradox table size limit 128 MB

Posted on 1998-09-20
8
477 Views
Last Modified: 2010-04-06
hi folks,

Config: Delphi 3.0 c/s, windows nt 4.0, bde-engine 5.0 with paradox table

I need to create a table that is larger than 128 MB. But each time Delphi stops at 128mb and says that it cannot append any more rows.

Is it possible to have a table larger than 128mb?
If so how do we configure this ??
0
Comment
Question by:tha_incredible_bo
  • 4
  • 3
8 Comments
 

Expert Comment

by:dejohn99
ID: 1340351
Have you tried removing all indeces?  I have found that many of the limitations of the Paradox system are related to the primary key rather than to the tables themselves.
0
 

Expert Comment

by:dejohn99
ID: 1340352
The other major issue I have run into with the BDE is the BLOB handling sub-system.  In D3 and below, it's flaky as all H under certain circumstances.

Also, the maximum table size is affected by the Block size of the table at create time.  This is set in the BDE administrator under Configuration -> Drivers -> Native -> PARADOX -> BLOCK SIZE.
0
 
LVL 1

Author Comment

by:tha_incredible_bo
ID: 1340353
there are no indices on that table. but it is a nice aspect if you can't have any indices on bigger tables!
0
 
LVL 3

Expert Comment

by:Matvey
ID: 1340354
I have a Paradox table that is 507 MB. It's on a CD, and I won't have enough space to copy it to the HD. It doesn't open in the database desktop, it says the index is corrupt, but it works fine with the application that uses it. The application is quite old, and I supose so is the table. SO , my guess: try to use an old version of Paradox tables (Paradox 3.5, 4 etc.). I supose this might have a chance...

--Matvey
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Expert Comment

by:dejohn99
ID: 1340355
I have just tested a big Paradox table under D3 BDE, and had no problems.

1. Check your block size.  Paradox tables are limited by the number of blocks, and so the block size will limit the table size.

2. Are you using any "special feature" fields - such as BLOB, auto increment or lookup?  If yes, try changing those fields to Integer or string fields.

3. What is your record size?
0
 
LVL 1

Author Comment

by:tha_incredible_bo
ID: 1340356
hi dejohn99,

the settings for the blocksize seem to be the problem. i increased the value to 32k and now it works fine.

regarding to your question: i do not use any special fields. my structure looks like this:
id int, tag smallint, tagord smallint, text alpha(255), link int.

the next problem i encountered is the limit of 2 GB for the paradox table. is that the upper final end for a paradox table or can you go beyond that limit perhaps with some tricks like striping? (perhaps you have an idea???)

please send your comment as an answer to receive the points.

many thanks for your helping
bo
0
 

Accepted Solution

by:
dejohn99 earned 100 total points
ID: 1340357
The paradox standard (See your BDE manuals) has an upper limit of 2GB per table.  For larger tables I would recommend using a SQL based system if possible.  If it is not possible to do this, you could try splitting your data into tables by ID range, perhaps with a master table to indicate which actual table to get the data from.  I have done this to split data into tables by job number here.

My email address is dejohn99@telusplanet.net.  This sounds like an interesting problem, depending on how much table transparency you need.
0
 
LVL 1

Author Comment

by:tha_incredible_bo
ID: 1340358
thanx dejohn99, i'll keep you informed via e-mail about my problems and solutions ...

CU ;o)
Bo
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Activex loadlibrary and show parented form issue 6 264
code issue 8 85
Run video youtube webbrowse 10 45
select query - oracle 16 82
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

760 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

21 Experts available now in Live!

Get 1:1 Help Now