Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Paradox table size limit 128 MB

Posted on 1998-09-20
8
Medium Priority
?
490 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
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.

 
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
 

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 400 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

810 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