Performance issue with vS2005

  • Thread starter Thread starter touf
  • Start date Start date
T

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