Tool for Pardox database

#1

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Thanks in advance for your response.

#2

Quote:

However, the file sizes for the Paradox tables did not decrease like I
expected them to.

deleting records from a paradox table does not reclaim the dead space..

Quote:

Is there a tool that I could use that would compact the tables to reflect
the new amount of data?

there is a "restructure" process built into paradox (the software package)
that packs the tables and indexes..

if you will be working with paradox tables, you should use paradox, not
access, to do it.. you can buy inexpensive older copies on my web site
and/or on ebay..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"kryten" <Kryten98008 (AT) gmail (DOT) com> wrote

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Thanks in advance for your response.

#3

Quote:

However, the file sizes for the Paradox tables did not decrease like I
expected them to.

deleting records from a paradox table does not reclaim the dead space..

Quote:

Is there a tool that I could use that would compact the tables to reflect
the new amount of data?

there is a "restructure" process built into paradox (the software package)
that packs the tables and indexes..

if you will be working with paradox tables, you should use paradox, not
access, to do it.. you can buy inexpensive older copies on my web site
and/or on ebay..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"kryten" <Kryten98008 (AT) gmail (DOT) com> wrote

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Thanks in advance for your response.

#4

Quote:

However, the file sizes for the Paradox tables did not decrease like I
expected them to.

deleting records from a paradox table does not reclaim the dead space..

Quote:

Is there a tool that I could use that would compact the tables to reflect
the new amount of data?

there is a "restructure" process built into paradox (the software package)
that packs the tables and indexes..

if you will be working with paradox tables, you should use paradox, not
access, to do it.. you can buy inexpensive older copies on my web site
and/or on ebay..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"kryten" <Kryten98008 (AT) gmail (DOT) com> wrote

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Thanks in advance for your response.

#5

Quote:

However, the file sizes for the Paradox tables did not decrease like I
expected them to.

deleting records from a paradox table does not reclaim the dead space..

Quote:

Is there a tool that I could use that would compact the tables to reflect
the new amount of data?

there is a "restructure" process built into paradox (the software package)
that packs the tables and indexes..

if you will be working with paradox tables, you should use paradox, not
access, to do it.. you can buy inexpensive older copies on my web site
and/or on ebay..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"kryten" <Kryten98008 (AT) gmail (DOT) com> wrote

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Thanks in advance for your response.

#6

Quote:

However, the file sizes for the Paradox tables did not decrease like I
expected them to.

deleting records from a paradox table does not reclaim the dead space..

Quote:

Is there a tool that I could use that would compact the tables to reflect
the new amount of data?

there is a "restructure" process built into paradox (the software package)
that packs the tables and indexes..

if you will be working with paradox tables, you should use paradox, not
access, to do it.. you can buy inexpensive older copies on my web site
and/or on ebay..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"kryten" <Kryten98008 (AT) gmail (DOT) com> wrote

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Thanks in advance for your response.

#7

Quote:

However, the file sizes for the Paradox tables did not decrease like I
expected them to.

deleting records from a paradox table does not reclaim the dead space..

Quote:

Is there a tool that I could use that would compact the tables to reflect
the new amount of data?

there is a "restructure" process built into paradox (the software package)
that packs the tables and indexes..

if you will be working with paradox tables, you should use paradox, not
access, to do it.. you can buy inexpensive older copies on my web site
and/or on ebay..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"kryten" <Kryten98008 (AT) gmail (DOT) com> wrote

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Thanks in advance for your response.

#8

Quote:

However, the file sizes for the Paradox tables did not decrease like I
expected them to.

deleting records from a paradox table does not reclaim the dead space..

Quote:

Is there a tool that I could use that would compact the tables to reflect
the new amount of data?

there is a "restructure" process built into paradox (the software package)
that packs the tables and indexes..

if you will be working with paradox tables, you should use paradox, not
access, to do it.. you can buy inexpensive older copies on my web site
and/or on ebay..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

"kryten" <Kryten98008 (AT) gmail (DOT) com> wrote

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Thanks in advance for your response.

#9

kryten wrote:

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Paradox "recycles" the space in a database file. Records are stored
in "blocks," and when all of the records in a block are deleted the block
is placed onto a free-list for reuse.

It's actually very inefficient to grow or to shrink a file in most
filesystems, so Paradox doesn't shrink a file at all and it grows a file
only when the free-space list is exhausted. This is by design.

Furthermore.... you'll see that Access does the same thing. Pretty much
every database management system does it.

----
ChimneySweep(R): Fast(!) table repair at a click of the mouse!
http://www.sundialservices.com

#10

kryten wrote:

Quote:

I have a legacy tool that uses Paradox database files. There are some
tables that are too large and I used Access to delete records from
them. However, the file sizes for the Paradox tables did not decrease
like I expected them to. Is there a tool that I could use that would
compact the tables to reflect the new amount of data?

I know that Access has to be compacted on occasion because the objects
in the database keep their memory size even though data or code has
been deleted.

Paradox "recycles" the space in a database file. Records are stored
in "blocks," and when all of the records in a block are deleted the block
is placed onto a free-list for reuse.

It's actually very inefficient to grow or to shrink a file in most
filesystems, so Paradox doesn't shrink a file at all and it grows a file
only when the free-space list is exhausted. This is by design.

Furthermore.... you'll see that Access does the same thing. Pretty much
every database management system does it.

----
ChimneySweep(R): Fast(!) table repair at a click of the mouse!
http://www.sundialservices.com