CODEWITHSUNDEEP
androidandroid-listviewandroid-fragmentssimplecursoradapter
connoisseur
connoisseur

Reputation: 507

ListFragment delay when displaying data

First off thanks to all the users who have made my android developing adventure so much easier. I have, however, come across a situation for which I don't find a solution so here goes:

I have an Activity which contains various Fragments which are intended to interact with each other. These include:

  1. a Fragment containing a GridView populated by a SimpleCursorAdapter from one table in the Sqlite db

    // Grid Functionality

public void PopulateGrid(){
dba = new myDB(getActivity().getApplicationContext());
dba.open();
Cursor c = dba.getRows();
if (c!=null){
String[] columns = new String[]{col_1, col_2, col_3, col_4};
int[] to = new int[]{R.id.grid_id, R.id.grid_desc, R.id.grid_value, R.id.grid_image};

newAdapter = new SimpleCursorAdapter(getActivity(), R.layout.grid_item, c, columns, to); 

View v = getView();
GridView gv = (GridView)v.findViewById(R.id.sale_grid);
gv.setAdapter(newAdapter);
gv.setOnItemClickListener(itemSelected);

}
}

  2. a ListFragment which is populated by another SimpleCursorAdapter from a different table // List Functionality

    public void PopulateList(int index){
Log.v("sell list", "Populate list started");
dba.open();
Cursor cursor = dba.getList(index);
if (cursor!=null){
String[] columns = new String[]{col_1, col_2, col_3, col_4, col_5};

int[] to = new int[]{R.id.code, R.id.description, R.id.qty, R.id.price};

newAdapter = new SimpleCursorAdapter(getActivity(), R.layout.list_row, cursor, columns, to); 
this.setListAdapter(newAdapter);

}
dba.close();

}

  3. When the user selects something from the GridView, the Activity inserts the item in the ListView's table and then reinitializes it.

    @Override
public void onGridClicked(Long value) {
insertItem(value.toString());
}
//do stuff

public void insertItem(String result) {

    // Add item
    dba.addItem(result, qty, index);
    //Re-populate Panels 
    long start;
    long end;

    start = System.currentTimeMillis();
    refreshPanels(index);
    end = System.currentTimeMillis();
    Log.v("Refresh List:", "Time"+(end-start));

}
private void refreshPanels(int index){
    lf.PopulateList(index);
    ListView lv = lf.getListView();
    lv.setSelection(lv.getCount()-1);

}

Now for the problem: When I look at the logs and Log each step. This entire process take no more than 50-70 ms but from the time I click on the Grid to the time the ListView is updated I can literally count 2-3 seconds. It seems that the issue lies in the ListFragment and the time it takes to setListAdapter() and refresh the View.

I have tried various ways of going about this such as 1. using an Interface to listen for the selection or calling it directly from the GridView fragment 2. calling a secondary function in the ListFragment with either newadapter.changecursor(c) or newadapter.getCursor().requery() 3. other variants of this...

But it always seems to take forever any help please..

Upvotes: 0

Views: 1973

Answers (2)

Scientist
Scientist

Reputation: 11

If you make your SQLite operation fast, the UI thread can update the UI faster. Use beginTransaction(), setTransactionSuccessful, endTransaction().

Upvotes: 1

connoisseur
connoisseur

Reputation: 507

thanks for the help, turns out the issue is not in the ListView loading the data, but rather the GridView taking too long to register the click see topic 5197438 Now I gotta figure out a way around it...

Upvotes: 0

Related Questions