Ajay-Pandey
Databricks MVP

When you specify a trigger interval that is too small (less than tens of seconds), the system may perform unnecessary checks to see if new data arrives. Configure your processing time to balance latency requirements and the rate that data arrives in the source.

There is no specific measure for this because it totally depend on your use cases.

Ajay Kumar Pandey