Are the duplicates evenly distributed? You might have started on a big chunk
of dupes.
I'd go about this by loading my new data in a new table, removing the dupes,
then inserting all the new data into the old table. That way you have more
granular information about the process. And you can do
Hi everybody!
I'm new in mailing list, and i have a little question.
The tables are:
postalcodes (place_id, code), PK(place_id, code) 600K of rws
places (id, name), PK(id), INDEX(name) 3M of rows
I've to insert another 600k of rows into postalcodes table, in a single
transaction, omitting du
