My memory is the CDX is sent as soon as you open the table along with the header from the DBF? I bet Christof knows all the details... 😊
--
rk
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Thursday, January 25, 2018 2:03 PM To: profoxtech@leafe.com Subject: Does the CDX file travel across the network for each time a field that can use an index is queried/updated/deleted/added? (was Re: Indexes on VFP tables--when do they get updated)
Perhaps a better question at this point: Does the CDX file get pulled down locally for every query? I would think for ADD/UPDATE/DELETEs, it would get updated on the LAN. (In this scenario, the database is on a network folder; not local.)