Only showing first x rows of a Database in a listview
<p>I'm building an app that contains a listview that is populated from a database query. The list works fine but I'm worried that I may start to display too much data when database gets larger. I would like to display the top 25 entries then add a list item called "show more" at the bottom of the list where I could append the next 25...</p>

<p>Is it better to preform a second database query for the next 25 and append them to the current list?</p>

<p>Or</p>

<p>Store the entire returned dataset in the ArrayList object on the initial database query and update the ListVew by cycling through the arraylist?</p>
