Subject RE: Insert into Large Table is slowly!
Author
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.
≧▽≦

jimmy


--- In firebird-support@yahoogroups.com, <aharrison@...> wrote:

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