Solved

Paradox table size limit 128 MB

Posted on 1998-09-20
8
482 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: 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!

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
select query - oracle 16 103
Multiple image collision 13 106
TEMBEDDEDWB how can i change its user agent ? 8 104
Firemonkey DbLookupComboBox equivalent ? 2 77
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…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

732 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