4 ms·
I've been tackling the same problem (in a similar architecture recently (though more real-time oriented)). Some other suggestions: 1. Hash the names (with
by bsaunder 18y ago
I've been tackling the same problem (in a similar architecture recently (though more real-time oriented)). Some other suggestions:
1. Hash the names (with something like Text::DoubleMetaphone) and select from this list rather than trolling the whole database.
2. Check out POE (great for distributed parallel processing)
3. Consider how you will handle null fields (a lack of information is not the same as badly matching information).
4. Consider the uniqueness of the data values themselves (Ebenezer Rumpelstilzchen is more unique than John Smith), but you have to watch out for foreign names (which seem unique but aren't).
5. Matching on multiple fields seems multiplicative, not additive.
- jrockway 18y agoNumbered lists are not code, so please don't format them that way. They break the page. (HN really needs some CSS that restricts the width of code blocks.)
- Xichekolas 18y agoThere is a GM script that does this (PRE-fix), but with javascript: http://userscripts.org/scripts/show/25039 http://userscripts.org/scripts/show/25039 I tried with CSS alone, but as I recall it was inconsistent in multiple browsers, so went with js.
- jrockway 18y agoOK. The CSS I have on my blog seems to handle long code snippets pretty well, but I can't explain how it works, since I just ported a Typo theme. Regardless, it seems possible. Someone that actually has a clue about CSS and/or Javascript should submit a patch to fix HN :) (Unfortunately, I do not have said clue.)