Joe,
each of the tables involved also had a parent table. that was also being
copied.
It turned out that the parent table copy (insert .. select) was taking over 50%
of the time. So I flattened the tables including the neccessary fields into the
children tables.
This doubled the throughput in 2 places, actually creating the original and for
the copy component.
Thanks for your patience and allowing me to bounce ideas.
Ken
Joe Wilson <[EMAIL PROTECTED]> wrote: Forget about the alternate insert
statements I suggested.
Assuming "id" is declared INTEGER PRIMARY KEY in all tables,
you can't get better performance than this in a single
insert statement:
insert into x select x1.* from a.x x1, y where x1.id = y.id;
____________________________________________________________________________________
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545433
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
