Re: [firebird-support] RE: Insert into Large Table is slowly!

[Hugo Eyng]

GTT?
Em 05/09/2013 13:35, jym...@gmail.com escreveu:

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Â

--


Atenciosamente,

Hugo Eyng