Sadly I've been developing with obj-c for almost 4 years and still don't feel I have a handle on this ...
sqlite database with 3 columns: title, pub_year, copies_sold. I'd like users to be able to sort by pub_year or copies_sold and have the database rows displayed in the appropriate UITableView sections (i.e., a section for 1990, 1991, 1992, etc; or - 1 copy sold, 2 copies sold, etc). The issue I run into is the database has over 1000 rows already, and users can add more rows, so the information is not static. Due to the high number doing a "SELECT *" from the database and then sorting into appropriate sections with a 'for loop' takes a bit of time. I'm wondering if it is possible to have the sqlite database sort data into groups executing a SELECT command, as this would be much faster in an indexed database.
Any suggestions on how best to accomplish this would be greatly apprecaited.