I have multi-user EDB applications where each user connects to a local instance of the EDBSRVR on their machine to access data and updates to a cloud server link users together.

Right now I am never optimizing the tables in my databases on these systems (I haven't had any of them running for terribly long I am thinking I should probably put some automatic optimization into these systems.

On conventional LAN systems I have JOBs which optimize all the tables in the database from time to time.

* If I call "Optimize" for any of my users on my cloud-based systems does this affect the UPDATE file?
* Does calling Optimize impact on the cloud update process at all, or is it just a local process?

... I am guessing the answer to both the above questions is "no" & that I can go ahead & call optimize freely, but I would like to check for issues & gotchas first.

Adam,

<< * If I call "Optimize" for any of my users on my cloud-based systems does
this affect the UPDATE file? >>

No.

<< * Does calling Optimize impact on the cloud update process at all, or is
it just a local process? >>

No.

(I'm assuming that all of the above is being done on the local systems that
connect to your cloud server).

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com