I think the disparity is caused by the WHERE IN query will match first name OR last name. So, John Smith and Peggy Brown will both be returned if the import name is John Brown.
The fact that the OP's query return all records is because the query is selecting them all. Of course, if there aren't exactly 24 matches in the table, maybe this needsa to be revisted. BTW, aside from not properly matching first and last name together, the WHERE IN query (at least with MySQL) is very expensive, generally. Oh, and don't forget to create an index on (fn, ln) for both tables. On Thu, Mar 27, 2008 at 11:39 PM, jonknee <[EMAIL PROTECTED]> wrote: > > > Now, here's where we stand... > > > > jonknee's query took about 25-27 seconds and returned 154 records. > > > > b logica's query took about 6 seconds and returned 24 records > > Sounds about right, except for the difference in number of dupes. How > many are there in total? > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
