Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace In - is it slow?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00496131
Message ID:
00496166
Views:
16
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform