I see a potential problem when multiple users are doing updates on the same table. What constitutes the server file to be updated? How do the localized cdx files know to update when the server version is updated?
On Thu, Jan 25, 2018 at 12:51 PM, Gene Wirchenko <ge...@telus.net> wrote: > At 08:15 2018-01-25, mbsoftwaresoluti...@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. >> > > I think it *is* a fair test for exactly that reason. If you see only > one of the IDX index files change, that suggests that VFP only updates an > index where it would make a difference. > > I grant that it could be that that optimisation does not exist in the > CDX handling, but how likely do you think that is? > > Sincerely, > > Gene Wirchenko > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMY+bKhtfZuKEzcG8WLW5sx+ku8D=+85r3o2e7guw-vp...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
