[sqlite] Virtual Table query - why isn't SQLite using my indexes?

Per Richard's request, I have produced the WhereTrace for the query that uses virtual tables and the same query that is not using virtual tables. That output is at the end of this message. Ultimately, I think my question is, how should I respond to xBestIndex such that SQLite will perform the

[sqlite] Limit size of write-ahead log file

The PRAGMA max_page_count statement lets me set a limit on the size the database is allowed to grow. This is useful to protect myself against accidental errors in my program, where I fill the file system with a huge database file, which could disrupt other processes that are trying to write the sa

[sqlite] REGEXP pcre DLL for Windows

Dear SQLite Users, may i kindly ask again about REGEX pcre DLL for Windows? Do someone have an idea or even a precompiled DLL which works under sqlite? Best regards Martin -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mail

[sqlite] REGEXP pcre DLL for Windows

On 5/18/15, Keith Medcalf wrote: > > Is there any reason why the default REGEXP is unsuitable? > > ext/misc/regexp.c > > in the source distribution ... > Just in case it helps to answer the above question The RE syntax recognized by regexp.c is summarized in the header comment which can be p

[sqlite] REGEXP pcre DLL for Windows

Is there any reason why the default REGEXP is unsuitable? ext/misc/regexp.c in the source distribution ... > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of sonypsx > Sent: Monday, 18 May

[sqlite] REGEXP pcre DLL for Windows

On Mon, May 18, 2015 at 9:43 AM, sonypsx wrote: > may i kindly ask again about REGEX pcre DLL for Windows? > > Do someone have an idea or even a precompiled DLL which works under sqlite? As you've found, you don't just need a pcre dll for windows, you need a sqlite3 module to implement the callba

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

Eric: Can you please recompile the SQLite shell (sqlite3.exe) with -DSQLITE_DEBUG and -DSQLITE_ENABLE_WHERETRACE and then run your query after first running .wheretrace 0xff And then send us the output? (In order for this to work, you'll have to build your virtual table implementation as a s

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

Are you setting the constraintUsage return parameters correctly? SQLite ist asking two questions: 1) What is the cost of a full table scan on table inventory (your answer is 4581; I personally would leave idxNum=0 for this case) 2) What is the least cost of doing a partial table scan with any c