|
|
||||||
|
#1
06-22-06, 12:12 PM
|
|
|
|
|
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 |
|
|
|
#2
06-22-06, 03:28 PM
|
|
|
|
|
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 Boaz Ben-Porat wrote: [..] |
|
|
| Similar Threads | |
| sp runs much slower than same query ran in QA This query involves 3 tables: CREATE TABLE [VPOFF] ( [VACYEAR] [smallint] NOT NULL CONSTRAINT [DF_VPOFF_VACYEAR] DEFAULT (0), [OFF_COD] [char] (4) COLLATE... |
|
| Query works in Query Analizer but not as part of a table adapter I'm trying to run a query to return all of the customers who have not placed an order. This query runs fine in Query Analizer but when I try to run it as part of a table... |
|
| A query runs 1 times slower from a .NET application the from Query Analizer 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... |
|
| ADO.NET Query Execution time is 10 times slower than via Query Analyzer Hi, I have the stored procedure which uses temporary tables and does some calculations. It executes in 3 sec when I use Query Analyzer. When I execute it using ADO.NET... |
|
| SP runs slower than same query in Query analyzer. Why?? My boss created three identical tables, future, present, past and data lives in any one of these tables depending on the date. For reporting I created a view as... |
|
|
All times are GMT. The time now is 11:58 AM. | Privacy Policy
|
A query runs 10 times slower from a .NET application the from Query Analizer