[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Paradox table size limit 128 MB

Posted on 1998-09-20
8
Medium Priority
?
488 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

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…
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

650 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