to use it for filtering a set of data (via SQL query) instead of looping through the data-set and perform some if/then-filtering?
My app receives a set of data. Let's say "buildings" with 1-500 buildings per set, depending on what the data source gives me.
Sometimes I want to display all houses, sometimes only those with a minimum amount of windows and sometimes those with red roofs.
The buildings are displayed immediately and don't need to be stored for later.
Is SQLite a good idea then or is it too slow?
500 rows is nothing relevant to extract from the db
Обсуждают сегодня