Duplicate checking

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • livewire
    Senior Member
    • Nov 2016
    • 100

    #16
    Originally posted by yuri
    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

    • livewire
      Senior Member
      • Nov 2016
      • 100

      #17
      Originally posted by yuri
      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

      • livewire
        Senior Member
        • Nov 2016
        • 100

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

        Comment

        Working...