A query runs 10 times slower from a .NET application the from Query Analizer

B

Boaz Ben-Porat

Computer: 3.4 Ghz CPU, 1 GB RAM, 2003 Server

database : MS SqlServer 2000 Enterprise. ~ 10 GB database file. Largest
table in the database contains 11,000,000 records.

Framework: .NET 2.0

I try to run a query against the database, selecting aggregated data from
views based on the large table.
When executed from the Query Analizer, it takes 13 seconds.
When executed from a .NET application, it takes 140 seconds.

The database is well tuned (or else the query analizer would go slowly), so
I can't find the reason for this difference.

Any suggestion ?

TIA
Boaz Ben-Porat

Milestone Systems
 
B

Bryan

Boaz,

I'm not a DBA, but if you post the code your using to run the query,
maybe I, or someone else here will be able to pick out something...

- Bryan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO.NET Query Execution time is 10 times slower than via Query Analyzer 11
First connection to the database (Oracle) from a .Net console application takes 6 sec 3
slow append query from a pass through query 4
Performance Issue With SQL Server Mobile 2
Query 10 times slower (and results reordered!) from ASP.NET page than console app. 15
Passing query parameters from a form 1
When using transaction, the stored procedure takes 10 times longer, why? 6
Launching .net forms from non .net application - reducing overhead 1

Top