SQLite is definetely not slow. So far I've only had the need to move a single database operation into a background thread, and that's only because I need to actually read every row returned (as opposed to just to display them in a list).
On Oct 12, 7:08 pm, Mark Murphy <[email protected]> wrote: > Move the database work to a background thread. Add appropriate indices > to your table to speed up your queries. Use Traceview to determine > what specific operations are slow. > > > > > > On Wed, Oct 12, 2011 at 6:14 AM, John Goche <[email protected]> > wrote: > > > Hello, > > > I would like to know whether there is any way to speed up my SQLite queries. > > Every time I press a button on my UI that needs database access it stalls > > for > > half a second or so. What should I do? > > > Thanks, > > > John Goche > > > -- > > You received this message because you are subscribed to the Google > > Groups "Android Developers" group. > > To post to this group, send email to [email protected] > > To unsubscribe from this group, send email to > > [email protected] > > For more options, visit this group at > >http://groups.google.com/group/android-developers?hl=en > > -- > Mark Murphy (a Commons > Guy)http://commonsware.com|http://github.com/commonsguyhttp://commonsware.com/blog|http://twitter.com/commonsguy > > Warescription: Three Android Books, Plus Updates, One Low Price!- Hide quoted > text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
