[sqlite] Two equivalent queries with very different perf

2014-05-25 Thread Andrew Arnott
, new object[] { this.RemoteParty.Id }); var slow = await this.Database.QueryAsync(@" SELECT m.Id FROM Message m WHERE m.RemoteContactId = ? AND ( SELECT COUNT(Id) FROM Attachment a WHERE a.MessageId = m.Id ) > 0", new object[] { this.Remo

Re: [sqlite] Windows Phone 8.1

2014-05-04 Thread Andrew Arnott
I'd love to see it as well. Now that my app is ready for submission to the Windows Phone store, I find that the Sqlite available through Tim Heuer's blog prevents my app from being accepted by the store because this build of sqlite uses disallowed APIs. -- Andrew Arnott "I [may] not

Re: [sqlite] Windows Phone 8.1

2014-04-21 Thread Andrew Arnott
I found this, which offers a private build of a Universal compatible version of SQLite. http://timheuer.com/blog/archive/2014/04/17/universal-windows-apps-nuget-sdk-references-sqlite.aspx -- Andrew Arnott "I [may] not agree with what you have to say, but I'll defend to the death your right t

Re: [sqlite] Windows Phone 8.1

2014-04-21 Thread Andrew Arnott
don't know. I was hoping to find the answer here. -- Andrew Arnott "I [may] not agree with what you have to say, but I'll defend to the death your right to say it." - S. G. Tallentyre On Fri, Apr 18, 2014 at 5:50 PM, Ryan Finnesey <r...@finnesey.com> wrote: > Hi Lane > &g

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-11 Thread Andrew Arnott
Hi Joe, Thanks for the workaround. It works! Is there a place where a bug should be filed to track this? -- Andrew Arnott "I [may] not agree with what you have to say, but I'll defend to the death your right to say it." - S. G. Tallentyre On Tue, Mar 11, 2014 at 3:30 PM, Joe Mista

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-11 Thread Andrew Arnott
, SQLiteOpenFlags openFlags, Boolean storeDateTimeAsTicks) InnerException: I tried adding sqlite3_set_directory to the sqliteWP8.cpp file but it got too intense for my limited C++ knowledge. -- Andrew Arnott "I [may] not agree with what you have to say, but I'll defend to the death your

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-10 Thread Andrew Arnott
=SQL logic error or missing database Source=Dart.WinPhone8Lib StackTrace: at SQLite.SQLiteCommand.ExecuteNonQuery() InnerException: Thanks for any help you can offer! -- Andrew Arnott "I [may] not agree with what you have to say, but I'll defend to the death your right to

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-10 Thread Andrew Arnott
I expect I could build a miniature repro if that would be useful to anyone. On Mar 10, 2014 8:05 PM, "Andrew Arnott" <andrewarn...@gmail.com> wrote: > It raises an error, which the sqlite.cs file that everyone uses turns into > an exception. > On Mar 10, 2014 6:01

Re: [sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-10 Thread Andrew Arnott
It raises an error, which the sqlite.cs file that everyone uses turns into an exception. On Mar 10, 2014 6:01 PM, "Simon Slavin" <slav...@bigfraud.org> wrote: > > On 11 Mar 2014, at 12:56am, Andrew Arnott <andrewarn...@gmail.com> wrote: > > > When I upgra

[sqlite] SQLite on Windows Phone 8 fails on "VACUUM" command

2014-03-10 Thread Andrew Arnott
When I upgraded from the SQLite for WinPhone8 SDK v3.8.1 to 3.8.3.1, the VACUUM statement quit working. Any idea why? I'd be quite happy to 'rollback' to 3.8.1, but I can't find a way to download prior versions of the SDK. Thanks. -- Andrew Arnott "I [may] not agree with what you have t