We have many tables which require to be updated once a day in IOK file from our database. Can we define the specific starting time (for each interval) to update and publish data, it will be helpful that we can define the time to be executed to avoid the peak load hour on the DB.
Then, we can schedule and control the updated time for each table to avoid the congestion?
In IOK file, it has many tables imported from DB (whole table) and some database blocks imported only newly added/updated records.
For the database blocks which will fetch the whole table, I would like to schedule them to run once a day/week to prevent overload on the DB server and the network. Some data blocks which will fetch only newly added/updated records, I would like to schedule them to run every one hours. In the update option, there has the option which we can set the schedule to run every hour.
But we can not set the startup time, so we could not know exactly when the database block will be updated. I think it might be useful if we can expect the time which each database blocked will be updated. Then, we can schedule to update data during the time that database has very low access.
Summary of this idea: in the DataManager block "Update options" dialog, have another option to specify "At specific time(s) of day".
(but if you have a Server license, I would advise using the Scheduler to configure whatever update intervals you need, using interim IOK files to separate the different data sources with different refresh intervals/times).