At 12:21 2018-01-24, Ted Roche tedroche@gmail.com wrote:

[snip]

<OldWarStory> I once worked on an app where the original developer thought it would be a "clever" idea to define index expressions as UDFs. Yes, it's

It seems to me that it might be useful in some very limited circumstances.

possible. In his UDFs, he would switch work areas, open tables if not already opened, look up values, and then return the value, cleaning up work areas and tables as he went. For every index definition for every record. A reindex with more than a couple hundred records brought the entire system to its knees.

</OldWarStory>

That does seem like a lot of unnecessary work. Wouldn't the tables needed already have been open? Or did he have SET ARCHITECTUREASTRONAUT ON?

[snip]

Sincerely,

Gene Wirchenko