On Thu, Sep 5, 2013 at 3:50 AM, <jym013@...> 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