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]
-----------------------------------------------------------------------------


Reply via email to