"Debi" <de**@nospam.com> wrote in message
news:3C**********************************@microsof t.com...
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
I suspect that the Windows and Console apps are not quite as identical as
you think. Different use of libraries/Objects, open closing connections,
etc. can make some amazing differences in performance.
There are a few items one could guess at, but I suggest you actually
measure/profile the app to find out exactly where it is spending its time
and examine that code.
See if any of this helps...
http://dotnet.sys-con.com/read/46342.htm
-ralph