473,320 Members | 2,004 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

VS2005 + Enterprise Library : SQL queries takes longer to execute

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
Oct 26 '05 #1
1 1546
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

"Philippe Trottier" <Ph**************@discussions.microsoft.com> wrote in
message news:B5**********************************@microsof t.com...
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

Oct 26 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: paul | last post by:
Hi, Im trying to add a dataset to the app_code directory using vs2005 \ SQL2005 beta 2. When I run through the wizard I select the option to auto create new Stored Procedures (Select, update,...
0
by: Amelyan | last post by:
Does anyone know when they plan to release Enterprise Library for VS2005? The latest version I have is Enterprise Library 2005 June. That version has a problem with schema (and VS2005 does...
0
by: Jim Crate | last post by:
<<finishing message this time, after accidentally sending before>> I have a couple queries in a PL/PGSQL function which execute very slowly (around one minute each) which execute in .5 second...
1
by: Philippe Trottier | last post by:
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...
2
by: chris_doran | last post by:
Firstly, let me come clean and say I don't really know what I'm doing. Classic tale: I'm using some code developed by a third party who is now uncontactable. Further, he did it in C# and .NET...
5
by: Sudharsan | last post by:
Hi I have developed a Windows Control Library in VC.NET The component will play back video files and this component is used in C# applications to display multiple videos simultaneously. The...
7
by: Joe | last post by:
Hello All: I am trying to use the Enterprise Libraries created by Microsoft to update a DB2 database and am stuck. I need to be able to Insert, Update and Delete records from the DB2 datbase...
8
by: Daz | last post by:
Hi everyone. I was faced with the choice of whether my problem is indeed a PHP problem or a MySQL. I have decided it's a PHP problem as I don't experience the same problem when I execute the...
23
by: Nishant Saini | last post by:
Dear All, We have a database which contains many tables which have millions of records. When We attach the database with MS SQL Server 2005 Standard Edition Server and run some queries (having...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.