Announcement

Collapse
No announcement yet.

Duplicate checking

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Originally posted by yuri View Post
    How much time does it take to run this query:

    Code:
    SELECT SQL_NO_CACHE `id` FROM `lead` WHERE `first_name` = 'some name' AND `last_name` = 'some name' AND deleted = 0
    MySQL returned an empty result set (i.e. zero rows). (Query took 0.0036 seconds.)

    Comment


    • #17
      Originally posted by yuri View Post
      Does it take long if you import leads w/o email addresses so that only the name is checked for duplicates.
      when i skip the emails its much faster

      Comment


      • #18
        i assume if i check only duplicates by the phone number rather than name and email it will be much faster

        Comment

        Working...
        X