Console application takes forever to access data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Debi said:
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
Click to expand...

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
 
Back
Top