[sqlite] Two equivalent queries with very different perf

2014-05-25 Thread Andrew Arnott
[] { this.RemoteParty.Id }); -- 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 agree

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 I was wondering if you have

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 to say

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 right to say

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 Mistachkin sql

[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 to say

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 upgraded from the SQLite for WinPhone8 SDK v3.8.1

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 PM, Simon Slavin slav...@bigfraud.org

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

2014-03-10 Thread Andrew Arnott
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 say it. - S. G