On Thu, Sep 5, 2013 at 3:50 AM, <[email protected]> wrote: > > > I insert data use follow: > 1. start a transaction > 2. Insert a batch records into temp table TableTemp, It's structure like > table1 > 3. Insert into Table1 select * from TableTemp > Delete Data From TableTemp > (about 30,000 record every tiime) > 4. commit transaction > > but now, insert data become very 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?
Good luck, Ann
