Hi,

I've created a console application which is scheduled to run every morning
to pull out some reports. The data retrieval is through stored procedures
which takes a max of 2-3 mins to run. But the console application takes more
than 6 minutes to run each stored proc. So as the number of reports starts
increasing, the application is taking forever to execute. I've noticed that
the same procs. if called from a windows form returns faster.
Does anyone have a hint on speeding up things.
Thanks in advance,
Debi