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 |
|
Rliss
Starting Member
31 Posts |
 Posted - 2008-02-28 : 13:18:48
|
| I have a summary table with a 9 field composite primary key. Every 10 minutes, my system generates 2 files of 500,000 to 750,000 rows to be summarized into this table. I first Bulk insert those into a temp table, and then trigger an inner-join update query to do the updates, followed by a left-outer join to do the inserts. As the day goes on, millions of rows in my summary table, this process is too slow. Any ideas about causes/solutions???RLiss |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-29 : 01:13:11
|
| What indexes do you have on the summary table?This would be useful to know as this can have a big impact.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 21:26:29
|
| Do you really need pkey on 9 columns? |
|
|
|
|
|
|
High volume I/O!!!