What would be the impact on perfomance if i configure Daily Time Window for Large Queries instead of increasing list view threshold?

Does it mean the same as increasing list view threshold for a specific time period?

Kindly help.


Yes, effectively you are telling the system to go ahead, run the query and don't worry about locking tables or response times. It's an appropriate way around not being able to run the queries at all.

I manage the large list SSRS reports this way, where reports don't need to be run in real time and "last nights" position is plenty good enough.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.