×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Btrieve file size doesn't decrease when I delete

Btrieve file size doesn't decrease when I delete

Btrieve file size doesn't decrease when I delete

(OP)
When a betrieve record is deleted out of a btrieve table, the file size doesn't decrease (Just out of interest I am interested to know what happens to this record, is it filled with ascii zero's?)

I am left with a situation where if I delete loads and loads of records from a LARGE betrieve table, the file continues to be as big.  Is there any purging tools or even functionality within butil to clear out of these deleted records?

Your response is appreciated!

RE: Btrieve file size doesn't decrease when I delete

When a record is deleted from the Btrieve file, the entries in the PAT and KEY are removed. The record is not "zeroed" out but it marked as free space. Which is why the file doesn't shrink.  The Pervasive engine will reuse that space the next time an insert is done.  You can remove this extra space by using BUTIL (-CLONE and -COPY) or a third party tool like the Btrieve Rebuild DLL (available at http://www.mirtheil.com/rebuild.asp) if you want to do it programmatically.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Btrieve file size doesn't decrease when I delete

(OP)
Thank you kindly Mirtheil.  

I am probably being a bit thick, but what is PAT?  I assume it is Pervasive something or other.

RE: Btrieve file size doesn't decrease when I delete

PAT is the Page Allocation Table.  It's an internal Pervasive structure for storing the pages that store the data.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Btrieve file size doesn't decrease when I delete

(OP)
Thanks for the advice/information Mirtheil.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close