Easier way of pausing builds


#1

We have some databases that can take hours to rebuild. These databases are set to rebuild whenever the sync process completes. So in the middle of the day, when working on modifying data being synced or adding additional data to sync, it’s important to pause these builds while the new data is synced and changes made to the DBs.

Currently, the only way I believe to do this is by going to each database and turning off it’s scheduled rebuild, then when complete, turning the schedule back on.

At the very lease, I’d like to be able to select all the database and change the schedule, vs doing each one individually.

An alternative to changing the schedules might be an option to “Pause” builds, then “Unpause” when done. (In the case the schedules vary, you don’t have to remember the schedule setting for each DB)

Ideally would be an option to “Pause for X hours”. What has happened to me in the past is I’ve turned off the schedule on the DBs, spent a number of hours on syncing new data and redesigning DB, and forget to turn schedules back on. I don’t realize it until the next day when I get a bunch of users calling about the data being incorrect.

I know this doesn’t affect a lot of people, but as someone who has been spending a lot of time over the past weeks adding data to Phocas, it would be a huge help!


#2

Hi Aaron,

I’ve been having the same issues as you; when I’m adding features to an existing database, I will add fields to the queries, sync the data and then go into designer to use the new fields. Any databases set to OnSync, are already rebuilding when I get there, meaning I have to cancel the builds.

Because this situation only really applies to the UI version of Sync, and not the CLI version, I was pondering if the solution might be to have two buttons in Sync; “Sync Now” and “Sync & Build Now” - the first one would just move the data without triggering any rebuilds, meaning you could safely modify data without having to worry about the impact.

I think that would be easier than having a pause option. What do you think?


#3

One possible method to achieve this is to create a separate sync item - a dummy sync of a tiny squirt of data. In designer Set the onsync build to be triggered on that source.
When you want to “pause” just disable the sync command in task scheduler. Re-enable it to resume normal build.

Just an Idea