database

Question

i have fifty lakh record in my database how to search a specific person? and if i use select query then it take lot of time,,, Any method to solve this problem...