General information
Category:
Coding, syntax & commands
From the Hacker's Guide: "The help hints and our tests confirm that REPLACE is generally faster than UPDATE. In exclusive mode, the differences are small, but with shared tables, we see tremendous differences. The reason for the difference is that UPDATE uses record locking while REPLACE locks the entire table. There may be cases where you can't lock the table, so UPDATE's behavior can save your skin in spite of its performance consequences".
>Can somebody tell me the difference between using "replace" and "update"?
>
>I'm using regular VFP database (not MSSQL), I don't use views and usually, I open the tables with buffering mode 5.
>
>I usually use "replace" and never got problem but I've seen other programmers using "update" and I would like to understand the difference, advantages and pitfalls of both commands.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only