Performance issue with vS2005

13 Nov 2007 5:39 AM

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

13 Nov 2007 7:12 PM

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

14 Nov 2007 9:46 AM

Miha Markic

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

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"touf" <tou***@hotmail.com> wrote in message
news:eTzu$dbJIHA.4228@TK2MSFTNGP02.phx.gbl...
> 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
>