>>Perhaps with the selfsame command, but adding an index on the key expression - an index on
dtos(dTraBan) + cRefBan..., especially in the historical file.
>
>Thanks Hilmar. Tried and didn't seem to help much.
>
>Alex
Other options include an outer join, and doing a SET RELATION to the history table (copy those that have something like
eof("HistoryTable")). I am not sure whether any of these options would be faster.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)