Freechain errors

[Dick Burke]

On Thu, 21 Dec 2006 11:58:21 -0500, Don Coleman wrote:

> This
>file would normally grow to a maximum of 40,000 records on any given day.
>All "completed" records are then archived to another file each evening after
>the close of business.  So if I understand freechain correctly, this file
>should never grow larger than the max size of 40,000 records.  However,
>within a week or 10 days it will be > 100,000 records.  I assume this occurs
>because the application is "taking" new records when there are free
>(previously deleted) records available.  My understanding of the freechain
>function is it acts as a pointer for the next record to be used.  If there
>are previously deleted records available to be reused they would be reused
>first before the app. takes a new record.  


Could this be batched to include the K or L flags to clear out the file after nightly archive.

>As mentioned above, the frequency of the freechain errors increases with the
>file size.  When the file was >150,000 records it was happening at least
>daily, if not twice daily.  Any suggestions? 

>Don Coleman
>Donald G. Coleman, Consultant
>402 Andrew Circle
>Indiana, PA 15701
>dcoleman at dgcreact.com
>(724) 349-6302


>_______________________________________________
>Filepro-list mailing list
>Filepro-list at lists.celestial.com
>http://mailman.celestial.com/mailman/listinfo/filepro-list


Dick Burke