Slow stored procedure calls?

I'm using stored procedures that are compiled against a view of a large (wide) table. The procedure calculates some averages based on input parameters. When the view contains only 80 rows or so, the porcedure is quick. If the view contains 300 rows the procedure is slow for the exact same query (obviously the speed is a function of the recordset). Is there any way to improve this? Most of the problem is exasperated by the fact that the view and the procedure body and built and compiled on the fly, and then called on the fly.

Thanks in advance...

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 03 1999 - 13:05:29 CDT