android - Loading a BIG SQLiteDatabase in a ListActivity -

-

i'm working on android project need finish fast.

one of app's features loading sqlite database content , listing in listview inside listactivity.

the database contains few tables, among 2 large.

each item in database has many columns, out of need display @ least 2 (name, price), although preferably 3.

this might seem pretty easy task, need in part of app read database , list it. did without problems, testing app versus small sample database.

in first version, used cursor query, arrayadapter list's adapter, , after query loop cursor start end, , each position add cursor's content adapter.

the onitemclicklistener queries database again versus other parameters (basically open categories) clears adapter, loops cursor , adds content adapter on again.

the app worked charm, when used real-life, big database (>300mb) got app taking long display contents, , blocking.

so did research , started using simplecursoradapter automatically links contents of cursor listview using usual parameters (string[] from, int[] etc., used android.r.layout.simple_list_item_2 , android.r.id.text1 , text2).

problem is, doesn't change time load.

i've came across suggested solutions on different web sites , tutorials, of them using, in 1 way or another, asynctask class. tried implementing manually myself it's hard keep track of multiple threads , failed.

tutorials keep telling how content providers, found nothing clear bout specific situation: big sqlite database -> read listview.

now head filled in notions loadermanager, loaderadapter etc, mixed , confused in head.

can please provide me complete, nice, clean solution "simple" task?

again: want read big sqlitedatabase , display in listview. want app not block.

i need class has member function takes parameter query , listactivity's context , takes care of displaying result of query in view.

please don't provide me abstract answers. i'm running out of time , i'm confused right , need clean complete solution.

you're hope.

if query such large database take tym, need find smart way,

like limit database query first 10 or 30 items , maintain,once last item reached query rest 30 items , bind them

refer tutorial, teach how add data dynamically in list view

http://p-xr.com/android-tutorial-dynamicaly-load-more-items-to-the-listview-never-ending-list/

the above list has expired chk this

http://mobile.dzone.com/news/android-tutorial-dynamicaly


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more