| View previous topic :: View next topic |
| Author |
Message |
drammo
Beginner
Joined: 13 Jan 2006
Posts: 20
Topics: 10
|
 Posted: Wed Jan 25, 2006 1:27 pm Post subject: Insert Vs Load |
 |
|
I have a program which formats data and inserts into a DB2 table. For each run, there will be thousands of inserts. Performance wise, is it better to write the formatted records into a dataset and then do a LOAD RESUME?
All thoughts are welcome. |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Wed Jan 25, 2006 1:51 pm Post subject: |
|
|
drammo,
A Load utlitiy with sorted(on the primary key) input will always outperform program Inserts.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
drammo
Beginner
Joined: 13 Jan 2006
Posts: 20
Topics: 10
|
| Posted: Thu Jan 26, 2006 9:09 am Post subject: |
|
|
| Will LOAD be an overkill for a few thousand records that too when the table is not being accessed by any other application? |
|
| Back to top |
|
|
Manas Biswal
Intermediate
Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India
|
| Posted: Thu Jan 26, 2006 9:44 am Post subject: |
|
|
drammo,
| Quote: |
Will LOAD be an overkill for a few thousand records that too when the table is not being accessed by any other application?
|
How can load be an overkill when a program isn't. I would say that coding a program to do the inserts would be an overkill.
And if the table is not being accessed by any other application, thats a perfect candidate for load.
HTH...Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948) |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
