Re: [sqlite] Does wal-file support MMAP?

2017-11-10 Thread advancenOO
Purely for speed :) I hope to improve the performance inside sqlite in order to optimize the performance of the upper applications. As there are so many different scenes in APPs. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users

Re: [sqlite] [EXTERNAL] Re: Does wal-file support MMAP?

2017-11-10 Thread Hick Gunter
I take it you have already fine tuned your database schema and statements to utilize optimum query plans, which may cut orders of magnitude from execution times and found the performance to still be lacking. -Ursprüngliche Nachricht- Von: sqlite-users

Re: [sqlite] Does wal-file support MMAP?

2017-11-10 Thread Simon Slavin
On 10 Nov 2017, at 8:49am, advancenOO wrote: > Purely for speed :) > I hope to improve the performance inside sqlite in order to optimize the > performance of the upper applications. As there are so many different scenes > in APPs. hAve you optimised your column

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
Brent Ashley has a nice blog post on integrating your languages regular express processing into sqlite: http://www.ashleyit.com/blogs/brentashley/2013/11/27/using-regular-expressions-with-sqlite/ On Fri, Nov 10, 2017 at 8:15 AM, Stephen Chrzanowski wrote: > I'd take

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
A good StackOverflow post on adapting in C# for use in Linq queries: https://stackoverflow.com/questions/24229785/sqlite-net-sqlitefunction-not-working-in-linq-to-sql/26155359#26155359 On Fri, Nov 10, 2017 at 8:31 AM, Don V Nielsen wrote: > Brent Ashley has a nice blog

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
Assuming you are looking for "Abc" or "Def" anywhere in the argument, how about regular expression? (Abc|Def) On Thu, Nov 9, 2017 at 3:00 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > On 11/9/17, 2:51 PM, "sqlite-users on behalf of Stephen Chrzanowski" < >

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Stephen Chrzanowski
I'd take regular expressions, sure, but, how do you get SQLite syntax to take that on? On Fri, Nov 10, 2017 at 8:45 AM, Don V Nielsen wrote: > Assuming you are looking for "Abc" or "Def" anywhere in the argument, how > about regular expression? (Abc|Def) > > On Thu, Nov 9,

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Peter Da Silva
Looking back through the thread, from the original post: > I'm using the amalgamation by default, so I don't think FTS is in the DLL. I > can recompile, but that now introduces complications on machines that may not > have this exact DLL. (A couple people in my company use this app) The same

[sqlite] User function's alias

2017-11-10 Thread korablev
I have noticed strange behaviour of user functions. Consider following example: #include #include #include "sqlite3.h" static int callback(void *NotUsed, int argc, char **argv, char **azColName){ int i; for(i=0; i

Re: [sqlite] User function's alias

2017-11-10 Thread Jens Alfke
> On Nov 10, 2017, at 9:51 AM, korablev wrote: > > I have noticed strange behaviour of user functions. Consider following > example: In reports like this, it really helps if you can clearly state the situation at the start, instead of dumping hundreds of lines of code and

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Jens Alfke
> On Nov 10, 2017, at 6:50 AM, Peter Da Silva > wrote: > >> I'm using the amalgamation by default, so I don't think FTS is in the DLL. >> I can recompile, but that now introduces complications on machines that may >> not have this exact DLL. (A couple people

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Richard Hipp
On 11/10/17, Stephen Chrzanowski wrote: > I'd take regular expressions, sure, but, how do you get SQLite syntax > to take that on? Load the regexp extension here (https://www.sqlite.org/src/artifact/a68d25c659bd2d89) or one of the other 3rd-party regexp extensions that you