thank you for the quick response

the stored procedure only takes 4 parameters, so i wouldn't say that's too many

the tables the procedure runs against have a lot of data that...