Hi, [snip] > I have ensured that index are put in place for old table and new table. > There is no need of second level cache in this scenario. I have used UUID to > generate unique key when inserting new record. Yet this apps take 30 mins > for 40,000.
Indexes on the new table are going to hurt your insert performance. For large data loads, have you tried: 1 - push data into a table with no ref integrity (a load table) and no indexes 2 - asynchronously (after all the data has been loaded into the load table), call a stored procedure that copies the data from load to the real table 3 - after store proc has run, truncate the load table Kev
