Performance issue with vS2005

[touf]

Hi,
I've migrated from VS2000 (1st version of VS.NET) to VS2005,I'me having some
performance isssues
for example a query "Select * from table" that return 70000rows is taking
more than 1 min (instead of 5 sec in the previous version)
The same query takes 1 sec when I run it in the sql server management studio
express
PS: my application is in VB.NEt using an sqlserver DB in tha same machine

Any help please...
thanks

 

[Cor Ligthert[MVP]]

Touf,

The first version of VS Net was VS 2002.

However that is not so important, we probably cannot help you with the
information that you give us.

Although this is an AdoNet newsgroup are many people sending messages about
using DOA and things like that. It is for sure that DOA gives partially a
better performance then AdoNet. Therefore is the best to show us some code
about how you retrieve those 7000 rows.

Cor

 

[Miha Markic]

Try running two queries in sequence and see how the second one performs.