Retrieve random record from database each time i need it or get all records when app starts, put them into list and pick random record from this list?

Asked Feb 04 '18 at 15:41

Active Feb 04 '18 at 15:58

Viewed 19 times

I need to get random records from a database in my Android app pretty often. Is it better to retrieve all records from database into a list(when app launches) and then randomly pick record form the list? Or do a query to database every time i need to pull random record?

edited Feb 04 '18 at 15:58

asked Feb 04 '18 at 15:41

RekklesDroid

1

do a query to database every time is better one – Pankaj Kant Patel Feb 04 '18 at 15:44
You could just try both and measure the time – OneCricketeer Feb 04 '18 at 15:51

Retrieve random record from database each time i need it or get all records when app starts, put them into list and pick random record from this list?

0 Answers0