RE: [PHP-DB] Finding duplicate contacts..

2005-07-26 Thread Bastien Koert
t quicker You haven't posted the structure, so this is just a suggestion... Bastien From: "Bastien Koert" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], php-db@lists.php.net Subject: RE: [PHP-DB] Finding duplicate contacts.. Date: Tue, 26 Jul 2005 15:07:14 -0400 Obvious

Re: [PHP-DB] Finding duplicate contacts..

2005-07-26 Thread Micah Stevens
Sounds like it's going awefully slow, I have a table with several million entires, and it only takes 10-15 seconds to search through.. on a single processor system with 1 gig of ram too.. What's the query you're using? -Micah On Tuesday 26 July 2005 11:24 am, [EMAIL PROTECTED] wrote: > Ok,

Re: [PHP-DB] Finding duplicate contacts..

2005-07-26 Thread Martin Norland
Well, if you want to be as certain as you can - you're going to need to stick to a fairly rigorous check. What you could do is export the DB into something PHP can quickly load right in (something serialized, for e.g.) every X minutes, and then at the end of the day run your 'rigorous test'.

RE: [PHP-DB] Finding duplicate contacts..

2005-07-26 Thread Bastien Koert
elp or not, but something to consider Bastien From: <[EMAIL PROTECTED]> To: Subject: [PHP-DB] Finding duplicate contacts.. Date: Tue, 26 Jul 2005 14:24:05 -0400 Ok, I'm at a point where I'm just going to throw this out there and see if anyone has any good solutions because I&#x

[PHP-DB] Finding duplicate contacts..

2005-07-26 Thread tg-php
Ok, I'm at a point where I'm just going to throw this out there and see if anyone has any good solutions because I'm just not seeing one. Of course there's always a better solution, but I'm too brain dead right now to see it. So any input would be appreciated. Also..forgive me if this is more