There is a limit of 256KB (?) for your data for SQLite to be able to move backwards at a reasonable pace. Once you go over it, you will see a bunch of messages in the log and the move will become very slow and AFAIK, there is nothing you can do about it other than to optimize the size of your result set, such as by returning only columns that you need. I am not sure if that's the case in yoru situation, just figured I'd point it out.
On Oct 5, 3:27 pm, imran ali <imran...@gmail.com> wrote: > Hi all, > in my one application,using sqlite database i have to show approx > 17000 data from database one by one, > on backward & forward buttons.For that i have been using > cursor.moveToFirst(), cursor.moveToNext(), cursor.moveToPrevious(), > cursor.moveToLast(), > and showing desired result. > every thing is working fine except on cursor.moveToFirst() & > cursor.moveToLast(), it has been consuming more time that is > unacceptable. > i also tried with cursor.moveToPosition(int p); but face same problem. > > can any one help with some other good idea, that can optimize time to > move backward as well as forward? > > Regards > Imran ali -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en