MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: INSERT IGNORE ... SELECT performance question
Posted by: Rick James
Date: July 23, 2011 11:58PM

> I thought mysql would just stream the data
No. The UNIQUE index must be checked row by row.

Try my suggestion 5 or 6.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
INSERT IGNORE ... SELECT performance question
8168
John Nahlen
July 22, 2011 02:38PM
Re: INSERT IGNORE ... SELECT performance question
2711
Rick James
July 23, 2011 04:59PM
Re: INSERT IGNORE ... SELECT performance question
1774
John Nahlen
July 23, 2011 10:09PM
Re: INSERT IGNORE ... SELECT performance question
1419
Rick James
July 23, 2011 10:12PM
Re: INSERT IGNORE ... SELECT performance question
1626
John Nahlen
July 23, 2011 10:18PM
Re: INSERT IGNORE ... SELECT performance question
1482
Rick James
July 23, 2011 11:58PM
Re: INSERT IGNORE ... SELECT performance question
1808
John Nahlen
July 26, 2011 07:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.