If you have an unique id you could <span></span>use to match duplicated records then you could use a direct database query <div><br></div><div>Google "delete duplicate rows" or similar</div><div><br></div><div>After that you should delete the entries in crmentity and custom tables that do not match with any existing record</div><div><br></div><div>Cheers,</div><div>Conrado <br><br>El lunes, 27 de junio de 2016, Ranieri <<a href="mailto:rslemer@gmail.com">rslemer@gmail.com</a>> escribió:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>I have registered in leads over 2.5 million records</div><div><br></div><div>On import many were repeated several times</div><div><br></div><div>The size of the base using the find duplicates is not viable</div><div><br></div><div>Does anyone have an idea that I can use to clean the base and leave only one of each?</div><div><br></div><div>I have an ID field that could use, but I can not think of a solution to this.</div></div>
</blockquote></div>