what is the best way to get result for big data in databases?

i have a sqlite database with huge amount of records in it. for getting any result i am using select sql command to get result. but it s very slow for this amount of records. is there any algorithm for getting result of big databases faster than select sql command??