was just wondering what the best way was to design a database holding 29000 searchable names. in the past i have had much smaller groups of data to play with. how would it be best designed so it runs most efficiently? for example, i could maybe put all names into a different table depending on their first letter. you would think that would speed up your average query. but what if i want to search it by using the end of a string?
any and all ideas appreciated