>>I noticed today that updating a table installed on my local drive takes a long time (like 2-3 minutes, sometimes more). The table has approximately 150,000 records. The line of code is as following:
>>
>>
>>=tableupdate(1,.T.,"MyTableName")
>>
>>
>>I noticed also that the CPU usage goes up to like 50-55% during the update. Also, the status on the Window Task Manager Status goes into "Not responding". However, if I let it go on eventually the update finishes and the status goes back to "Running".
>>
>>Is the above normal when updating this size table?
>>
>>Thank you.
>
>Is that for updating multiple records at a time? Do you have any idea how many records are involved?
Yes, it is updating multiple records at a time. Approximately 90,000 records are being changed (I am guessing but will check in a min for sure).
UPDATE: about 130,000 records are being changed.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham