| Massive update processing [message #113932] |
Tue, 01 July 2003 11:16  |
Carol Cloyed
Messages: 2
Registered: July 2003
|
Junior Member |
|
|
We are attempting to update a 64 million row table by partition. There are 30 partitions with @ 2 million rows per partition.
It is taking 14+ hours to update if the process completes.
Several times the process seems to "hang up".
Is there any experience that you could pass on to help us overcome this roadblock?
Thank you.
|
|
|
|
| Re: Massive update processing [message #113952 is a reply to message #113932] |
Wed, 27 August 2003 08:22  |
Subhash Roy
Messages: 24
Registered: January 2001
|
Junior Member |
|
|
: We are attempting to update a 64 million row table by partition. There are 30 partitions with @ 2 million rows per partition.
: It is taking 14+ hours to update if the process completes.
: Several times the process seems to "hang up".
: Is there any experience that you could pass on to help us overcome this roadblock?
: Thank you.
: 30 partitions meaning 30 tables, each table on the different disk? Are the data distributed evenly across the tables? Have you ever thought of running 30 separate SQL statements, each stataement updating the specific table only? It's just a thought.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
