| loader utility - slow performance [message #648422] |
Tue, 23 February 2016 05:15  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
I am using sql loader for my data loading actually we received data on daily basis from different stations in different text files, every file contains around 14000 records.
There are lot of other checks who applied when data moving from temp tables to live database.
My problem is this operation is smooth running start of the month but after few days it works very slow even it took more than 30 minutes in a single station data.
Please suggest me whats I should do, how to improve its performance?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
