[sqlite] FTS multi-term union search (AND) is slow

Hello! The 'OR' queries is really fast, is it possible to speed-up a multi-terms union search (AND) queries? The "optimize" of the fts table does not resolve the problem. 1. Fast queries: sqlite> select * from data where data match 'AF8FD58037AFD629F13518658B94CD2C'; 0|0|zero|AF8FD58037AFD629F1

Re: [sqlite] Non-Debug version of SQLite3.dll

>>Looks like I was wrong. Supposedly "Rebase" can strip it out. Thanks for the tip on Rebase. Will check it out. >Why not just recompile the DLL yourself? I static link Sqlite directly >into my programs so, I don't have to worry about DLL versioning. My exe (winpatrol.exe) stays resident so

[sqlite] Incorrect example in the section 4.2 FTS3

link: http://www.sqlite.org/fts3.html#section_4_2 Section 4.2 The last statement of example: SELECT snippet(text, '[ ']', '...') FROM text WHERE text MATCH '"min* tem*"' Should be: SELECT snippet(text, '[', ']','...') FROM text WHERE text MATCH '"min* tem*"' to match explanation in the comment:

Re: [sqlite] Non-Debug version of SQLite3.dll

Hello Roger, Looks like I was wrong. Supposedly "Rebase" can strip it out. C Friday, April 2, 2010, 1:05:38 PM, you wrote: RB> On 04/02/2010 09:25 AM, bi...@aol.com wrote: >> When I build my setup program I get a message that says "File contains >> debug information". >> Is there a distributabl

Re: [sqlite] Non-Debug version of SQLite3.dll

Hello Roger, I find debug versions in Windows to be 2 or more times bigger than non-debug. I have a resource only DLL. Debug is 3.7 megs, release is 1.3. The debug executable is also 2-3 times larger. I'm not aware of any way to strip the debug information from the DLL. The linker can do it but,

Re: [sqlite] Possible bug in 3.6.23?

On Apr 2, 2010, at 4:23 PM, Kevin M. wrote: > Nope, somefunc isn't VFS related at all. In fact, that class only > makes one query itself and it calls the CMySQLWrapper class to > actually run the query and then grabs results from there. And the > method that makes the query would be the c

Re: [sqlite] Possible bug in 3.6.23?

Nope, somefunc isn't VFS related at all. In fact, that class only makes one query itself and it calls the CMySQLWrapper class to actually run the query and then grabs results from there. And the method that makes the query would be the caller, not the callee in a stack trace. Further, that me

[sqlite] Updated QSQLITE driver

Hello, has anyone an updated qsqlite driver that allows loading extensions? I tried building one myself without luck. I need the driver to bes used in windows, with PyQt. Marcelo ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

Re: [sqlite] Possible bug in 3.6.23?

What does CMyAppClass::somefunction() do? Is it your own VFS implementation? Pavel On Fri, Apr 2, 2010 at 1:06 PM, Kevin M. wrote: > I've had problems with update queries using sqlite 3.6.23 on Windows XP + > Visual Studio 2005 and am wondering if it is a bug.  sqlite seems to go off > into t

[sqlite] Possible bug in 3.6.23?

I've had problems with update queries using sqlite 3.6.23 on Windows XP + Visual Studio 2005 and am wondering if it is a bug. sqlite seems to go off into the weeds when calling sqlite3_exec(). I've also had the same behavior when using sqlite3_prepare_v2() + sqlite3_step() + sqlite3_finalize()

Re: [sqlite] Non-Debug version of SQLite3.dll

On 04/02/2010 09:25 AM, bi...@aol.com wrote: > When I build my setup program I get a message that says "File contains > debug information". > Is there a distributable SQLite3.dll that doesn't contain debug information > and might be a little smaller? You should be able to run whatever the Window

Re: [sqlite] Aliases in subqueries?

On Fri, Apr 2, 2010 at 1:59 PM, Igor Tandetnik wrote: > Fredrik Karlsson wrote: >> Sorry for asking this SQL question, but I just have to make sure: >> >> -  Aliases in subqueries - are the always, local to the scope of the >> subquery? >> >> >> That is, if I have this query (this example makes _

[sqlite] Non-Debug version of SQLite3.dll

I distribute the SQLite3.dll with my WinPatrol program. I obtained the last version from _http://sqlite.org/download.html_ (http://sqlite.org/download.html) When I build my setup program I get a message that says "File contains debug information". Is there a distributable SQLite3.dll that doe

Re: [sqlite] Query planner bug on max() function

It's not a bug. http://www.sqlite.org/optoverview.html#minmax Pavel On Fri, Apr 2, 2010 at 6:06 AM, Alexey Pechnikov wrote: > Hello! > > sqlite> select max(rowid) from role; > 1000 > CPU Time: user 0.00 sys 0.00 > > sqlite> select max(rowid)/100. from role; > 10.0 > CPU Time: us

Re: [sqlite] sqlite 3.6.23 may cause memory overrun problem

On Apr 2, 2010, at 8:34 AM, Daniel Lin wrote: > Let me describe the situation which I found: > > line 741 calculated as 17 bytes. > line 746 memcpy the zP4's original allocated size is 16 bytes only. > > So, on line 746, it will copy one byte unknown data on last byte to > the new buffer. http

Re: [sqlite] Aliases in subqueries?

Fredrik Karlsson wrote: > Sorry for asking this SQL question, but I just have to make sure: > > - Aliases in subqueries - are the always, local to the scope of the subquery? > > > That is, if I have this query (this example makes _no_ sense, I know. > Just an illustration.): > > select target.

Re: [sqlite] sqlite 3.6.23 may cause memory overrun problem

On Apr 2, 2010, at 6:15 AM, Daniel Lin wrote: > > I've read the test page which you provide. > But, I still think I'm right. Because Borland C++ Builder's Code > Guard detect by following method: > > 1. Make special tag on 'malloc' memory boundry. > 2. Check the memcpy is overrun the previous

Re: [sqlite] dead link on sqlite-announce info page

On Apr 2, 2010, at 12:20 AM, H. Phil Duby wrote: > Hi All, > > I just subscribed to the announce mailing list. The welcome message > includes a link to > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce, > which has a > link to the sqlite-announce > Archives

[sqlite] dead link on sqlite-announce info page

Hi All, I just subscribed to the announce mailing list. The welcome message includes a link to http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce, which has a link to the sqlite-announce Archives. I get a 404 error for the page at ht

[sqlite] whitespace for multi-line block comment not completely eliminated

Hi all, I seem to have found a bug, possibly related to http://www.sqlite.org/cvstrac/tktview?tn=234 and the linked checkin http://www.sqlite.org/cvstrac/chngview?cn=940 A 'C' style block comment that is not all on one line does not get ignored properly. If the line immediately after the comment

[sqlite] Aliases in subqueries?

Dear list, Sorry for asking this SQL question, but I just have to make sure: - Aliases in subqueries - are the always, local to the scope of the subquery? That is, if I have this query (this example makes _no_ sense, I know. Just an illustration.): select target.* from ( select target.* f

Re: [sqlite] SQLITE_DEFAULT_FOREIGN_KEYS support please

Hello! On Friday 02 April 2010 07:17:03 Kyle McKay wrote: > Then you could just add -DSQLITE_DEFAULT_FOREIGN_KEYS=1 to the > compiler options to have foreign keys always enabled by default. > > Anyone else interested in having support for this compiler option? Yes, it will be useful. I have a

[sqlite] Query planner bug on max() function

Hello! sqlite> select max(rowid) from role; 1000 CPU Time: user 0.00 sys 0.00 sqlite> select max(rowid)/100. from role; 10.0 CPU Time: user 1.512094 sys 3.732233 sqlite> explain query plan select max(rowid) from role; 0|0|TABLE role USING PRIMARY KEY ORDER BY CPU Time: user 0.00