Scheduling report every 2 minutes....would it affect performance?
I need to schedule my report every 2 minutes.
I save my report to a certain location as CSV file.
If the frequency is short like 2 minutes, would that affect performance...?
If you have experiences in this matter, could you please share...?
here at my company there used to be some reports that ran every 5 minutes dealing with a SQL Server database of some million records.
It affected the overall performance. My guess is , for the information provided , it wouldn´t affect the performance.