Re: Converting strings to ASCII codes to increase search

On Feb 19, 3:47 am, s1m0nc..._at_hotmail.com wrote:
> Hi,
>
> We have a system that contains 50M customer records. We need to
> repeatedly search this table to see if the new customer is actually a
> new customer or has been a customer of ours in the past.

So what criteria do you use to make such a determination? One of my customers has split in two, moving to a third address and changing name/phone/domain etc after previously buying competitors. Some of their customers have bought other customers...

>
> Some of the development guys have come up with the idea of converting
> some of the fields to their ASCII code representation as they think
> this will be quicker that doing straight string comparisons.

So you are not using ASCII? So your data is in a format with more information than ASCII?

>
> I have been trying to do some research around this and can't find
> anything that supports this.

Soundex?

>
> Has anyone come across this in the past or have any ideas.
>
> Thanks
> Simon

More analysis needed. And what everyone else said, including gazzag.

jg

--
@home.com is bogus.
"We don't have any beads, but you can flash us anyways." - heard on
radio.