Re: [sqlite] sqlite3 and sqlite4 disk I/O

2013-03-26 Thread Dan Kennedy
On 03/26/2013 06:34 AM, Rob Turpin wrote: Dan, I haven't heard anything more about this. I was wondering if you also think the CPU performance for sqlite4 should be better? Maybe you could help me with where I could focus my attention in looking into this. I know that's probably a big

Re: [sqlite] sqlite3 and sqlite4 disk I/O

2013-03-26 Thread Rob Turpin
A table with two columns, both integers, one column primary key. I iterate and insert 100,000 values. Then do 100,000 random updates. On Tue, Mar 26, 2013 at 4:30 AM, Dan Kennedy wrote: > On 03/26/2013 06:34 AM, Rob Turpin wrote: > >> Dan, >> >> I haven't heard anything

Re: [sqlite] Bug on real operations

2013-03-26 Thread Israel Lins Albuquerque
As I can see my problem is solved on sqlite 4. Em 08/03/2013, às 16:35, Israel Lins Albuquerque escreveu: > Thank you guys, and sort for my bad explanation about what I want. I > understand that double problems very well, > I will continue working with round. > >

[sqlite] looking up records with terms in a table

2013-03-26 Thread Gert Van Assche
All, I don't know if I can do this. I have a table T1 with Sentences and a table T2 with Terms. If I want to find all Sentences with the term "GM" I search like this: SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE '%GM%'; What I would like to do is look for all terms that appear in the

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Clemens Ladisch
Gert Van Assche wrote: > What I would like to do is look for all terms that appear in the Terms table. > Something like this (but of course this does not work): > SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE (SELECT Terms FROM T2); SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Gert Van Assche
Clemens, doesn't seem to work... The terms are just a part of the sentence, not a full match. Your query does find full matches. thanks gert 2013/3/26 Clemens Ladisch : > Gert Van Assche wrote: >> What I would like to do is look for all terms that appear in the Terms

[sqlite] System.Data.SQLite.dll

2013-03-26 Thread Ganesh Datta
Hi All, My application's(32 bit application) runtime prerequisite is .Net4.0. It uses the SQlite database.I am shipping System.Data.SQLite.dll (product version: 1.0.74). This setup works fine in Windows 7. But in Windows XP the same file System.Data.SQLite.dll is not able to connect to the SQLite

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Rob Richardson
I think you need wildcards: SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE %T2.Terms% RobR, not guaranteeing correct syntax -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assche Sent: Tuesday, March 26,

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Gert Van Assche
Rob, no that does not work either. Thanks for trying though. 2013/3/26 Rob Richardson : > I think you need wildcards: > > SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE %T2.Terms% > > RobR, not guaranteeing correct syntax > > -Original Message- > From:

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread James K. Lowden
On Tue, 26 Mar 2013 17:14:57 +0100 Gert Van Assche wrote: > SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE '%GM%'; > > What I would like to do is look for all terms that appear in the > Terms table. Something like this (but of course this does not work): > SELECT

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Clemens Ladisch
Gert Van Assche wrote: > 2013/3/26 Clemens Ladisch : >> Gert Van Assche wrote: >>> What I would like to do is look for all terms that appear in the Terms >>> table. >>> Something like this (but of course this does not work): >>> SELECT [Sentences] FROM [T1] WHERE [Sentences]

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Gert Van Assche
Bingo! Thanks you all! 2013/3/26 Clemens Ladisch : > Gert Van Assche wrote: >> 2013/3/26 Clemens Ladisch : >>> Gert Van Assche wrote: What I would like to do is look for all terms that appear in the Terms table. Something like this (but of

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Paul Mathieu
Try this: SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE CONCAT('%',T2.Terms,'%') Paul -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rob Richardson Sent: Tuesday, March 26, 2013 10:27 AM To: General Discussion of

Re: [sqlite] Newbie unable to get started with sqlite on Visual Studio 2012

2013-03-26 Thread Gilles Ganault
On Mon, 25 Mar 2013 17:46:17 -0400, wrote: >I installed slqite, its sqlite3 command line interface, and a GUI admin >console. Have built and populated a couple of databases. But what I really >want to do is to connect to sqlite databases from Visual Studio 2012 using

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Petite Abeille
On Mar 26, 2013, at 10:36 PM, "Paul Mathieu" wrote: > SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE > CONCAT('%',T2.Terms,'%') Alternatively, use FTS [1]: sqlite> create virtual table sentence using fts4( content text ); sqlite> insert into sentence values(

Re: [sqlite] looking up records with terms in a table

2013-03-26 Thread Gert Van Assche
Nice 2013/3/26 Petite Abeille : > > On Mar 26, 2013, at 10:36 PM, "Paul Mathieu" wrote: > >> SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE >> CONCAT('%',T2.Terms,'%') > > Alternatively, use FTS [1]: > > sqlite> create virtual table