t
quicker
You haven't posted the structure, so this is just a suggestion...
Bastien
From: "Bastien Koert" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], [email protected]
Subject: RE: [PHP-DB] Finding duplicate contacts..
Date: Tue, 26 Jul 2005 15:07:14 -0400
Obvious
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,
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'.
Obviously searching all the columns is creating a bottleneck, at first
glance I would consider some hashing on the values to make the search
simpler.
If home phone matches any existing home, work or alt phones.
If work phone matches any existing home, work or alt phones.
If alt phone matches an
