Strategy for handling variable time queries?

I have a typical scenario that I’m struggling with from a performance standpoint. The user selects a value from a dropdown and clicks a button. A stored procedure takes that value as an input parameter,...