|Subject||RE: Insert into Large Table is slowly!|
Maybe I've missed something about temporary tables, but it looks to me as if you're
doing two inserts and a delete per record. Â Why not just put the records into the
real table to start with?
Ann Harrison is right.
I just use GTT resolve a question at last week.
--- In email@example.com, <aharrison@...> wrote:On Thu, Sep 5, 2013 at 3:50 AM, <jym013@...> wrote:I insert data use follow:1. start a transaction2. Insert a batch records into temp table TableTemp, It's structure like table13. Insert into Table1 select * from TableTempÂ Â Delete Data From TableTempÂ Â (about 30,000 record every tiime)4. commit transactionbut now, insert data become very slowly.Maybe I've missed something about temporary tables, but it looks to me as if you'redoing two inserts and a delete per record. Â Why not just put the records into thereal table to start with?Good luck,AnnÂ