Google Style Optimized Search of a Database
This is an optimization style question.
I have a Dun and Bradstreet database circa 55M records. The request is that users need to look for a Company name. The company name is presently searched for using a wildcard search for example
Where Company Like '%Smiths%'
The problem is, this will do a row by row search and takes sometime.
Do this in Google for example, the return is blurringingly fast.
How can I optimize/write something to return records from a database using a wildcard, but at the same speed as something like a Google Search.
Need an optimization guru here? Atw?
|