PROBLEMS with large tables in Paradox 8 
Author Message
 PROBLEMS with large tables in Paradox 8

I'm having some great problems with Paradox 8. I've got to work with a large
table (about 9.000.000 records) and have to do some very simple queries on
this table. There's a primary index on the table (on the first two fields
while the table holds four fields in total). First of all I seem to get
errors opening the table in Paradox when I try to scroll to some records in
the middle or end and the queries seem to run very slowly (purely a calc max
on the first field takes about 40 seconds on my Pentium 450). The same
problem seems to occur if the table is only 2.000.000 records.

I've ported the data to MS Access and that would solve the problem (the
query returns immidiately). So if I get no answers this might be the
solution but I'll be throwing away a lot of work.

Has anybody got any experience in the above question? Is this just an
immense bug in IDAPI/BDE? Is this bug going to be recovered?

With regards,

Peter Kloprogge.



Sun, 08 Sep 2002 03:00:00 GMT
 PROBLEMS with large tables in Paradox 8

Hello Peter

Are you shure the block size of your table permits you to have suche
huges amount of data in your table ???

Remember that .DB file connot have more than :
128 Mo if page size is 2048 bytes
256 Mo if page size is 4096 bytes
512 Mo if page size is 8192 bytes
1Go Mo if page size is 16384 bytes
2Go Mo if page size is 32768 bytes

Access cannot have more than 1Go for ALL THE TABLES in a database...

So see the parameters of your BDE, and if the page size is not
correct, construct another table with a new page size
and fill the new table with the data in the previous version...

EG : 8 000 000 records is not a current thing under Paradox and you will
find quiclky the limits of Access first and Paradox second.
You must think to migrate to a real C/S database like InterBase
(low cost, no management to parameter it).

Frederic BROUARD - AMARIS SA Ile de France
Paradox - Delphi - SGBDR / RDBMS - SQL
http://perso.club-internet.fr/brouardf

More about PARADOX and SQL ?
http://perso.club-internet.fr/brouardf/Paradox_SQL.html
Peter Kloprogge a crit :

Quote:

> I'm having some great problems with Paradox 8. I've got to work with a large
> table (about 9.000.000 records) and have to do some very simple queries on
> this table. There's a primary index on the table (on the first two fields
> while the table holds four fields in total). First of all I seem to get
> errors opening the table in Paradox when I try to scroll to some records in
> the middle or end and the queries seem to run very slowly (purely a calc max
> on the first field takes about 40 seconds on my Pentium 450). The same
> problem seems to occur if the table is only 2.000.000 records.

> I've ported the data to MS Access and that would solve the problem (the
> query returns immidiately). So if I get no answers this might be the
> solution but I'll be throwing away a lot of work.

> Has anybody got any experience in the above question? Is this just an
> immense bug in IDAPI/BDE? Is this bug going to be recovered?

> With regards,

> Peter Kloprogge.



Sun, 08 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. large Paradox table problems

2. Problems with queries on large tables in Paradox 5 for Windows

3. Problems with queries on large tables in Paradox 5 for Windows

4. Problems with copy table with large tables

5. GPF after loading large Paradox table with MEMO field

6. Paradox Tables on large scale installations

7. Q: Is Paradox *.DB safe for large tables?

8. Large Paradox Tables and VB 3.0 PE

9. Large tables on Paradox 5.0

10. Index errors with large tables in Paradox 8

11. Paradox 5 for Windows: large tables

12. Paradox 5 for Windows: large tables


 
Powered by phpBB® Forum Software