I've designed an ASP.Net/VB.Net application that goes agianst both sql server and as400.
User can do name, address, phone number, etc searches.
*** I ONLY BRING BACK 20 ROWS of data *** this is because our database has too many indexes, wrong indexes or repeated indexes. Tables dont have Foreign Keys. I even broke my stored proc sql in 2 ...to first read from table1...dump into a temp table...join to table2 to cut back on # of resultsets and processing.
So, my coworker asked...how do other poeple ..for example...yellowpages.com do their searches. She said she can type in "jones" and get thousands of rows back and page thru them. My response was that their DB is designed correctly...
But she's right...how do sites like yellowpages.com can bring back so many rows....or even google...do they have a secret "search algorithm" ??