IN theory - the same test should be viable - just see if the CDX Timestamp was updated!
On 1/25/2018 11:15 AM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
On 2018-01-24 18:39, Fernando D. Bozzo wrote:
When the index is evaluated initially, VFP knows exactly what fields affect what index, so really just affected indexes are updated.
It's easy to test it. just make an old index (IDX) on two different fields:
CREATE TABLE test (field1 C(10), field2 I) INDEX on field1 TO test_f1 additive INDEX on field2 TO test_f2 additive
Add some data, wait a minute, replace one of the fields and do a FLUSH FORCE, and you will see that only the affected index changes his timestamp.
I don't think that's a fair test to use IDX files since this example uses a CDX file, and it's all in the same file.
[excessive quoting removed by server]