View Single Post
Old 09-30-2012, 08:26 PM   PM User | #9
Fou-Lu
God Emperor


 
Fou-Lu's Avatar
 
Join Date: Sep 2002
Location: Saskatoon, Saskatchewan
Posts: 15,635
Thanks: 4
Thanked 2,448 Times in 2,417 Posts
Fou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to all
In this case I don't know if there is an easier way around it. If you are using surrogate keys, then you need to check with the DB first either with manual iteration and checking, or using an INSERT SELECT statement.
Something still reeks though, given that the > the record count has an incremental slowdown like you are seeing, it still smells of either a datatype issue or an incorrect key setup (such as composite keys searching in the wrong order).
Fou-Lu is offline   Reply With Quote