I'm going to develop a phonebook-like application which is going to lookup among one million records for specified name. One of my main concerns is performance of lookups. So my questions are:
1- Is it feasible to have a SQLite database in android with 1M records?
2- Are there any know solutions to speed up database queries?
About 2nd question it comes to my mind to use Indexing and also breaking up database to several smaller databases. In case it is not feasible are there any know methods to handle this?