title: How many rows is ideal for an sqlite database for a "good citizen" app on android
body: <p>So I am deciding to use the sqlite database to cache server data. I am not sure how many rows is considered acceptable. Is 1,000 rows too many? Ideally I want to keep on the local phone as many rows as I can get away with. But I don’t want my app to slow down the phone of the user or have any adverse effect. So given the following schema, how many rows should I keep locally?</p>
  
  <p>table has 12 columns as: 1 blob, 2 real, 4 integer, 5 text. The blob is for thumbnail the size of a Youtube thumbnail.</p>
  
  <p>I am already aware of <a href="https://stackoverflow.com/questions/3482635/what-is-a-maximum-size-of-sqlite-database-on-android">What is a maximum size of SQLite database on Android?</a>. But that thread is for someone who wants to reach the limits. What I want to know is as a good android citizen, what is a safe number of rows to have? Or in terms of memory, how large should my db be so that my app plays well with others so to speak?</p>
  
  <p>For more context, my plan is to get the data from server to the db and to get data from the db through a CursorLoader that then talks to a RecyclerView.Adapter.</p>