Any reason why this is slow? DB is fast, .NET is

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Any reason why this is slow? DB is fast, .NET is

Author

Topic

dbwilson4
Yak Posting Veteran

50 Posts

Posted - 2007-06-11 : 16:23:32

Machine specs:
Intel Quad-core 6600 (2.4ghz, 2x 4mb cache)
DDR2-800 6gig
OS is Vista Ultimate.
The database is located in the data storage drive which is a western digital 7k rpm 400gig HD.

The DB size is 7gigs split into two file groups(3gig, 4gig). The tables I'm querying all have atleast 7 million rows.

The query itself is very complex and queries multiple tables at once with corr. subqueries and the query altogether is a page long.

When I run the query in the SQL Management studio (query analyzer), it takes half a second to run (it reports 0 seconds).However, when I run the query in .NET, it takes longer.

Any idea why this happens?

I can't post the DDL because it's very large.

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2007-06-12 : 00:02:58

make sure your application is not in debug mode.