|
View previous topic :: View next topic
|
| Author |
Message |
bipinpeter
Active User
.jpg)
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
Hi All,
I want to INSERT/LOAD RESUME data from a file in to a table.When we look for performance vise which one is the best option?
Using a program to insert records to tables or using a load job to LOAD RESUME the data?
Regards,
Bipin |
|
| Back to top |
|
 |
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
It depends how many records you are talking about...
Also in load table would be unavailable while with program data in the table can still be accessed. |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Bipin,
Performance wise LOAD would be better, since you are adding data to the table try it with SHRLEVEL CHANGE.
If you are going for INSERT statement, Checkout Multi-Row Insert
Regards,
Sushanth |
|
| Back to top |
|
|
|
|
