VS2005 + Enterprise Library : SQL queries takes longer to execute

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

Guest

Hi!

We developped a program with VS2003 and Enterprise Library. then we
switched to VS2005B2 to check the conversion between these two. Everything
works fine now except one thing!

The sql queries I execute on the database take much longer to execute. We
have for example a query that selects all rows from a table that contains
about 6000 rows. With VS2003 and any other sql tool it takes around 150-200ms
to execute. But now with VS2005B2 this query can take up to 20 seconds to
execute and during this time, the cpu usage is at 100%!!!

Can somebody give me a hint on that?? :)

BTW, we are using the iSeries generic provider with the enterprise library
(that we recompiled with VS2005.)

Thanx in advance!

Phil
 
Phil,

I think we have exchanged a bit before on this... You are using the iSeries
connector which has some known issues with VS2005. IBM has said that this
use at your own risk to us even with the fix that they provided. So there
could certainly be performance issues there.

Also, VS2005 is beta right now and betas typically run slower than the RTM.

So, lots of unknowns there. Give the RTM a try in a few days if you have an
MSDN subscription. That should isolate at least one variable.

If I can be of any other help, you can contact me via the feedback section
of the Haggen.com website. It will get routed to me.


Andrew Robinson
 
Back
Top