I've not seen anything on sqlite itself, but you can see the queries in sqlite-net using the Trace property on the SQLiteConnection class.
Most of the performance problems I've seen is if you use LINQ to get a big dataset then filter it in memory. I fixed it by using query so sqlite was doing the work, not sqlite-net. On Wed, Dec 5, 2012 at 11:41 PM, James Darbyshire <[email protected]> wrote: > Hi all, > > I have a problem with one of my apps and slow queries. > > Is there a way of tracing SQLite on monotouch? > > I am using Praeclarium's SQLite-net (but I think it would be outside this > layer). > > Regards, > > James Darbyshire > [email protected] > > > _______________________________________________ > MonoTouch mailing list > [email protected] > http://lists.ximian.com/mailman/listinfo/monotouch > -- Nic Wise t. +44 7788 592 806 | @fastchicken | http://www.linkedin.com/in/nicwise b. http://www.fastchicken.co.nz/ mobileAgent (for FreeAgent): get your accounts in your pocket. http://goo.gl/IuBU Trip Wallet: Keep track of your budget on the go: http://goo.gl/ePhKa Earnest: Self-employed? Track your business expenses and income. http://earnestapp.com Nearest Bus: find when the next bus is coming to your stop. http://goo.gl/Vcz1p London Bike App: Find the nearest Boris Bike, and get riding! http://goo.gl/Icp2 _______________________________________________ MonoTouch mailing list [email protected] http://lists.ximian.com/mailman/listinfo/monotouch
