> SELECT * FROM contactImport WHERE first_name IN (SELECT first_name > FROM contact) AND last_name in (SELECT last_name FROM contact)
That is a really bad query (for 30k records) and even don't solve the issue. > b logica's way would work too, so you could just check whatever is > faster. I don't have 30,000 records to test that out on :P. blogica's one seems to be right. > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---