Get whole sqlite records in android

Question

How can I get all records without using a loop.Loop is not a good way to get 1000+ records.

For example:

public List<Contact> getAllContacts() {
    List<Contact> contactList = new ArrayList<Contact>();
    String selectQuery = "SELECT  * FROM " + TABLE_CONTACTS;

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);
    if (cursor.moveToFirst()) {
        do {
            Contact contact = new Contact();
            contact.setID(Integer.parseInt(cursor.getString(0)));
            contact.setName(cursor.getString(1));
            contact.setPhoneNumber(cursor.getString(2));
            // Adding contact to list
            contactList.add(contact);
        } while (cursor.moveToNext());
    }
    return contactList;

But this is not a best way to do so.Think you have 5000+ record.How much time does it take to complete this task!

How do you think ?

Regards,

use CursorAdapter for your ListView (instead ArrayAdapter) and do not load data to POJO ... than list should be quicker(a lot) — Selvin, Mar 15 '13 at 09:08

nano_nano · Answer 1 · 2013-03-15T08:59:49.843

1

Select * from table;

thats all...

in Android:

Cursor cursor = database.query(SQLiteHelper.TABLE_YOURTABLE,
    allColumns, null, null, null, null, null);

I think a clearer way to iterate over the result:

cursor.moveToFirst();
while (!cursor.isAfterLast()) {
  Contact contact = new Contact();
        contact.setID(Integer.parseInt(cursor.getString(0)));
        contact.setName(cursor.getString(1));
        contact.setPhoneNumber(cursor.getString(2));
        // Adding contact to list
        contactList.add(contact);
}

edited Mar 15 '13 at 08:59

answered Mar 15 '13 at 08:25

nano_nano

12,351
8
55
83

I know this but I don't know how can I handle this.After this line you have to add all the records into a List with a loop.I do not want to use a loop for 1000+ records duo to the performance – Mobin Ranjbar Mar 15 '13 at 08:31
1

puhhh. good question. I dont think so... – nano_nano Mar 15 '13 at 08:37
thats why you got downvote @StefanBe – KDeogharkar Mar 15 '13 at 08:42
It depends on what you want to do with the data. That's why you got -4 votes on the question, because you don't specify anything... – Bogdan Zurac Mar 15 '13 at 08:42
1

@BaZinga: It was an easy answer for an easy question. I see no reason for the downvote... – nano_nano Mar 15 '13 at 08:46
even if you use that query you have to iterate the loop to get the data from the cursor. and i dont think thats possible. – KDeogharkar Mar 15 '13 at 08:48
You must iterate all the results or querry row by row, but that's far away from being a performance design. – r0- Mar 15 '13 at 08:53
I have edited my question with more details – Mobin Ranjbar Mar 15 '13 at 08:53
please take a look to my edited answer. I think thats a much clearer way to iterate over the result... – nano_nano Mar 15 '13 at 09:00
Thanks for you edit but does not solve my problem. – Mobin Ranjbar Mar 15 '13 at 09:20

score 0 · Answer 2 · edited May 23 '17 at 11:43

0

The only way to avoid loading thousands of records is to load less. (You won't be able to fit thousands of entries onto the screen anyway.)

You probably want to implement some form of lazy loading for your list.

edited May 23 '17 at 11:43

Community

1
1

answered Mar 15 '13 at 09:11

CL.

173,858
17
217
259

Good idea but how can I provide paging in a listview or something else to load step by step the data ? – Mobin Ranjbar Mar 15 '13 at 09:22

score 0 · Accepted Answer · answered Mar 15 '13 at 09:13

0

The Cursor itself represents the "list" of items. That's why I have asked you what do you need to do with the data after retrieving from database...

If you only need to splash it on a ListView, then use CursorAdapter. And even if you need to parse the "list" and send some items on the network or something other than displaying in a ListView, you still don't need an actual list. Just extract the items you need directly from the Cursor and send them away.

With the drawback of repeating myself, I should point out again: it really depends on what you want to do with the data.

answered Mar 15 '13 at 09:13

Bogdan Zurac

6,348
11
48
96

I have no problem with displaying the data.I want a solution that users can see all the data(with paging or something else) – Mobin Ranjbar Mar 15 '13 at 09:24
1

Like I already said above, use a CursorAdapter. – Bogdan Zurac Mar 15 '13 at 09:32

Get whole sqlite records in android

3 Answers3