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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2003-03-03 : 10:34:22
|
| here is my proc that updates records from DB to DB. I need this to be fast and efficient. Tables have about 2.5m recordsMy log file is growing out of control. Do I need to set batch logged or simple mode on to do this. Any suggestions.UPDATE aSET a.ordernum=c.ordernum,...FROM table aINNER JOIN table c ON (a.orderid=c.orderid )thanksslow down to move faster... |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-03-03 : 12:51:59
|
| What's your maint plan set up as? How many rows in c? How does c get populated? Why do you have to updated everything in c? Is loaded with new data everytime you process? How does a get the ordernum in the first place? If it's OLTP can't you add a trigger to do this? Do you have indexes on the join column? Is it Clustered?A little more background would be usefulLet us knowBrett8-) |
 |
|
|
|
|
|
update proc slow