Thanks. In this app, they indexed EVERY field, and the table in
question had a CDX size of 233 MB before I pruned it. Now it's down to
56 MB.
On 2018-01-24 14:35, Alan Bourke wrote:
Only the indexes that involve a 'touched' field. And even then it's
just a small update.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
On Wed, 24 Jan 2018, at 6:29 PM,
[email protected] wrote:
Question for you legends of the Fox (data):
Say Table1 has "X" number of indexes. Program code does something
like
the following:
IF Condition1 THEN
REPLACE Field1 with SomeValue in Table1
ENDIF
IF Condition2 THEN
REPLACE Field48 with Datetime() in Table1
ENDIF
Are each of the "X" indexes updated for each replace, even if those
indexes do not include any reference to Field1 or Field48, or only
indexes that are affected by the data value change?
I understand that ADDing and DELETEing records updated all indexes; I
would think the UPDATEs--regardless of what fields updated--would
cause
index updates for every indexed field on every update as well.
tia,
--Michael
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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.
