Demand Indexes and deleting records.

[scottwalker at ramsystemscorp.com]

Nancy,

That is a VERY interesting finding.  

In my mind that would make Demand indexes totally unusable on any system with more than one user, and maybe not even then.

If I created demand index.1 to include all employees in the state of "NC" and then someone deletes an employee record that was in "NC" and thus included in demand index.1, and then someone else adds a new employee record for an employees in "CA", if fp happens to get the same record number of the deleted "NC" employee and uses that record for this new employee, when I run my out process using demand index.1 to give all "NC" employees a 50% raise (since NC employees are the best), then the new "CA" employee (only working for the company for a few hours at this point) gets the 50% raise also.   The new employee thinks that is perfectly normal since that is the way they do things in "CA" �� so he doesn't report it to HR and the company is screwed.

Am I representing this correctly?

Regards,
Scott




-----Original Message-----
From: Filepro-list <filepro-list-bounces+scottwalker=ramsystemscorp.com at lists.celestial.com> On Behalf Of Nancy Palmquist via Filepro-list
Sent: Monday, December 14, 2020 12:11 PM
To: filePro Mailing List <filepro-list at lists.celestial.com>
Subject: Demand Indexes and deleting records.

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>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list