[sqlite] FTS4 snippets contains unintended content?

Good day. Anyone seeing additional content returned with the snippet text when using the OR (or AND?) MATCH Syntax - i.e. the field contents of the conditional fields MATCH clause? SELECT Target_Name, Target_Content, Target_Description, Target_Link, Parent_Short, Parent_Name, Parent_Link, A

Re: [sqlite] FTS4 snippets contains unintended content?

> RIM_API_FTS_DB MATCH 'bug report API_Version:374 OR API_Version:UAR' > > > [03:41] 1: [3.7.4] Release History Of SQLite ( http://j.mp/fHI3HG ) > ...generator bug introduced in version 3.6.14 . This bug ...status() > interface, in order to report out the amount of… 374 I think that is an expec

[sqlite] database file problem (even with correct path)

Hello, I'm using Django 1.2.4, with sqlite 3.7.4, and python 2.6.6. I'm on Windows XP at work, and using cygwin for command line. My path for Python is set through Windows' environment variables. I'm getting this error everytime I do ./manage.py syncdb Traceback (most recent call last): File "

[sqlite] FTS4 snippets contains unintended content?

Good day. Anyone seeing additional content returned with the snippet text when using the OR (or AND?) MATCH Syntax - i.e. the field contents of the field immediately prior to the snippet(blah) clause? SELECT Target_Name, Target_Content, Target_Description, Target_Link, Parent_Short, Parent_

Re: [sqlite] FTS4 snippets contains unintended content?

I don't know if it makes any difference...but I think you want some quotes in your match... MATCH '"bug report API_Version:374" OR "API_Version:UAR"' 2nd set of quote is needed as it appears a semicolon has special meaning to "match". You can see the offset are different if you don't quo

Re: [sqlite] EXTERNAL: FTS4 snippets contains unintended content?

I have to admit I'm an FTS neophyte so I'm trying to understand what's going on here. Here's the SQL: create virtual table data using fts4(content text); insert into data values('we got bug report API_Version:374 right here'); insert into data values('we got bug report API_Version:375 right here

Re: [sqlite] FTS4 snippets contains unintended content?

I have to admit I'm an FTS neophyte so I'm trying to understand what's going on here. Here's the SQL: create virtual table data using fts4(content text); insert into data values('we got bug report API_Version:374 right here'); insert into data values('we got bug report API_Version:375 right her

Re: [sqlite] sqlite Christmas rebus ( at least for me )

Hi Igor, this worked out :) Thank so musch for your help, and thank to all who answered my question Have a nice new year greetings from Rome, Giulio > Giulio Mastrosanti wrote: >> But the user can select to search for A records that MATCH ALL the B records >> selected, in

Re: [sqlite] FTS4 snippets contains unintended content?

Good day, Michael. Thank you for taking the time to respond. Per my (possibly ignorant) understanding of the FTS docs, this construct can be described as such: Construct: MATCH 'bug report API_Version:374 OR API_Version:UAR' Verbose: Perform an FTS search on the phrase 'bug report', and return

Re: [sqlite] FTS4 snippets contains unintended content?

Dan, Thank you, sir, for your response. Honestly, I don't really know. I had understood from the docs that all FTS snippet content returned would be wrapped in the 'ellipses' text (4th parameter of the snippet construct), with possible ellipses separating multiple token content in the event that

Re: [sqlite] FTS4 snippets contains unintended content?

What I find interesting is the results of some quick tests I did: http://gyazo.com/90b9a2ed6c5ec21086ac1968e4e86122.png (screen shot'd to keep the formatting in place [it seems that the list manager cobbles up some of the syntax/formatting of what I had sent initially]) The results seem inconsist

[sqlite] File locations

Hello: Is there a way to specify where sqlite3 should save database files? I am just starting to play with sqlite3 on a Windows box, and the utility always puts the files in a Local Settings folder. I haven't been able to find a way to change this behavior. Thank you, chris __

Re: [sqlite] File locations

i was able to do this on my win7 machine [ cd to wherever sqlite3 is] sqlite3 c:/testdb.db this also worked "c:\DropBox\My Dropbox/sqlite3" c:/anothertest.db HTH ~~~ Dave Watkinson On Wed, Dec 29, 2010 at 3:06 PM, Chris Schnaars wrote: > Hello: > > Is there a way to specify where sql

Re: [sqlite] File locations

Chris Schnaars wrote: > Is there a way to specify where sqlite3 should save database files? I am > just starting to play with sqlite3 on a Windows box, and the utility always > puts the files in a Local Settings folder. I haven't been able to find a way > to change this behavior. You can specify

Re: [sqlite] File locations

Dave and Igor: Thank you very, very much for your help and for responding so promptly. I was able to use the information you provided to do exactly what I needed. Thanks again! chris On Wed, Dec 29, 2010 at 3:06 PM, Chris Schnaars wrote: > Hello: > > Is there a way to specify where sqlite3 sho

[sqlite] clear cache for performance measure

How can I clear my sqlite db cache? I am comparing 2 different queries' running time but because results are cached and 2nd run of the same query execute much faster. Thanks! ___ sqlite-users mailing list sqlit

Re: [sqlite] clear cache for performance measure

On 30 Dec 2010, at 12:02am, KimTaein wrote: > How can I clear my sqlite db cache? > I am comparing 2 different queries' running time but because results are > cached and 2nd run of the same query execute much faster. I don't know whether it actually works, but setting PRAGMA cache_size = 0; PR

Re: [sqlite] clear cache for performance measure

You might also worry about your OS's page cache affecting your result. In modern linuxes you can say # sync # echo 1 > /proc/sys/vm/drop_caches That will free the page cache. Eric On Wed, Dec 29, 2010 at 6:11 PM, Simon Slavin wrote: > > On 30 Dec 2010, at 12:02am, KimTaein wrote: > > > How c

Re: [sqlite] clear cache for performance measure

Thanks Simon but that PRAGMA did not work Eric: I am on Windows. Is there a way to force OS cache other than restarting the machine? > Date: Wed, 29 Dec 2010 18:22:31 -0600 > From: eas@gmail.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] clear cache for performance measu

Re: [sqlite] clear cache for performance measure

On 30 Dec 2010, at 12:23am, KimTaein wrote: > I am on Windows. Is there a way to force OS cache other than restarting the > machine? Sorry, no. Windows maintains two relevant caches, and there's no way of clearing them short of rebooting. You can generate lots of your own data and fill the

Re: [sqlite] clear cache for performance measure

On Thu, Dec 30, 2010 at 3:23 AM, KimTaein wrote: > > Thanks Simon but that PRAGMA did not work > > Eric: I am on Windows. Is there a way to force OS cache other than > restarting the machine? > > > Kim, there's is a trick on Windows. There's a flag FILE_FLAG_NO_BUFFERING for file opening that

Re: [sqlite] clear cache for performance measure

On 30 Dec 2010, at 5:16am, Max Vlasov wrote: > On Thu, Dec 30, 2010 at 3:23 AM, KimTaein wrote: > >> Thanks Simon but that PRAGMA did not work >> >> Eric: I am on Windows. Is there a way to force OS cache other than >> restarting the machine? >> > > Kim, there's is a trick on Windows. Th

Re: [sqlite] clear cache for performance measure

Thanks Max! that works great! Thank you all for your answers. I learned a lot about cache today :) > From: slav...@bigfraud.org > Date: Thu, 30 Dec 2010 06:14:50 + > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] clear cache for performance measure > > > On 30 Dec 2010, at 5:16am, M