>>Hi George,
>>
>>I found the reason for slowness. You will laugh: I forgot to select WorkFile and therefore I scaned the main database table with 1,2 mln. records in it. No wonder, why it was so slow :)
>
>
That might help to explain it.:-) However, I did have an experience with appending data into a table that had multiple index tags that was so slow that the solution was to first delete all the tags, then re-build the index. So that will factor in. If there's still a problem with performance, I would suggest at least trying selecting the workarea beforehand and using SEEK() with only the expression. I seem to recall that REPLACE...IN is slower, but I'm not 100% sure of that, so I could be wrong.
Hi George,
Houston just wrote me, that I had to assign points for answering my own question. :) Well, I would not do this, but I give you two points for help.
If it's not broken, fix it until it is.
My Blog