> I have a CakePHP CRM application with 30,000+ contact records. Each > Contact hasMany Address records. One feature of my app is to allow my > client to search for duplicate entries within the contacts table > before importing new contacts. In short, I am querying the entire > Contact table and LEFT JOINing with the Address table. I store the > result set into an array and then use PHP's array functions to filter > potential duplicates from a "pending contacts" table.
What exactly are you doing? It can probably be handled pretty quickly by the database. You shouldn't have to manually fish out dupes. I always thought the please wait while we search messages were either a [poor] attempt to seem extra high-tech or a sign that they have a really inefficient system. Google searches the whole web--not just a day's commercial flights--and comes back in a flash. I have used a PHP app with a valid reason for it, it was a mailing list program and it accomplished sending large amounts of email out by batching (the page would keep reloading with incrementing GET variables, such as start=0&num=100). It wouldn't work in your case. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
