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.
| Author |
Topic |
|
Averno
Starting Member
10 Posts |
 Posted - 2001-04-04 : 07:20:38
|
| Running this query:INSERT INTO FACT_AGGR_IMP_1 SELECT TOP 110000 * FROM FACT_AGGR_IMPon my server (compaq 8000 4 cpu 1 GB RAM) takes 29 seconds, running THE SAME query with 120.000 instead of 110.000 takes 3mins14secs, almost 7 times more!! Who is the guilty? Is there a way to understand the why of this sudden performance crackdown? Thanks a lot, bye.Averno, Italy. |
|
|
|
|
|
Query Performance