Demand Indexes and deleting records.

[Nancy Palmquist]

filePro People,

I just noticed a very strange thing but it makes sense in a way.

Once a week I build a demand index with the oldest stuff in a very large 
database.  I then run through that index and delete items until I run 
out of time.

So I have an index with some items deleted and some not.

What I just noticed is that when new records are added into the slots 
where records were deleted, they seem to be included in the index. It 
makes sense in that the index has record pointers.  The data is not in 
sorted order but it is picking up the data on the record as if it should 
be in the index.

I offer this as a caution that if you are depending on a demand index to 
remain the same, you may be surprised if you are deleting records to 
find new records in their place in the index.

I am not entirely happy with this behavior but I can understand the 
cause. In all the years I have been using filePro I never noticed this 
behavior before and thought it worth mentioning.  I can't decide if I 
would qualify it as a bug or what.

Nancy

-- 
Nancy Palmquist
Owner
Virtual Software Systems - www.vss3.com
(412) 835-9417

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20201214/d62eb77a/attachment.html>