Publishing to a Production Database

The information in this article applies to product: e-Work 5.x 6.x

Discussion

  • It is not recommended that an e-Work procedure be published to a database that is experiencing heavy user activity. When a procedure is published, tables are locked and unlocked for the entire time the Designer is publishing. This can cause contentions within the database if the Engine is trying to execute long-running SQL queries, retrieve data, etc. at the same time the Designer is locking tables while publishing a large procedure.
Tagged: