I need more precise control over the timing of table lookups in AF, specifically the ability to schedule them at exact times (such as midnight) rather than relying on the current minimum refresh interval mechanism.
AF table connections currently support a minimum refresh time, not a specific scheduled time. This means if the refresh interval is set to 15 minutes, but no one requests the data for 30 minutes, the query is delayed until it's needed again.
Our databases typically update at midnight, and we want to trigger table lookups exactly at that time to ensure they are working with the most current data. Without this capability, we are forced to run queries more frequently than necessary, which increases system load.