On 2/18/08, Kalyani Phadke <[EMAIL PROTECTED]> wrote: > I have not recompiled sqlite 3 before. I am having trouble to find > documentation. > > Could anyone pls tell me how can I compile SQLite3 source code
http://www.sqlite.org/cvstrac/wiki?p=CompilingFts > windows xp machine. no idea about Windows. > Do I need to download FTS3 files ? Where can I find > those files? How can I add this extension to my sqlite??? The FTS source comes with the SQLite source (look in the ext folder). See the link above for detailed steps that worked for me on a Mac. > > Thanks > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor > Sent: Monday, February 18, 2008 11:10 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite Like Query Optimization > > On 2/18/08, Kalyani Phadke <[EMAIL PROTECTED]> wrote: > > I am trying to use FTS3 with SQlite3 . Do I need to recompile SQlite3 > > > to enable FTS3? > > yes. > > > > > From the command prompt I tried the following things > > > > Sqlite> .load libfts3.dll > > Unable to open shared library libfts3.dll > > Sqlite>select load_extension('libfts3.dll'); > > Sql error:unable to open shared library libfts3.dll > > > > So my question is The FTS3 module is available in SQLite version 3.5.6 > > > and later? > > > > Thanks, > > > > > > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor > > Sent: Monday, February 18, 2008 9:50 AM > > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] SQLite Like Query Optimization > > > > On 2/18/08, Kalyani Phadke <[EMAIL PROTECTED]> wrote: > > > > > > Suppose User typed 'test' in search text box, I would like to search > > > > the 'test' string in all the coulmns ... I do not want exact match.. > > > The columns could contain strings like 'tester' or 'tested' . I > > > should be able to get these records as well.. > > > > > > Hope I am clear explaining what I want.. > > > > you definitely should look into implementing full-text search using > > fts3. It will solve your problems as well as world peace. > > > > > > > > > > -Thanks > > > > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of BareFeet > > > Sent: Friday, February 15, 2008 4:38 PM > > > To: General Discussion of SQLite Database > > > Subject: Re: [sqlite] SQLite Like Query Optimization > > > > > > Hi Kalyani, > > > > > > > select ID from TableA where column2 like '%test%' or column4like > > > > '%test%' or column5 like '%test%' or column6 like '%test%' or > > > > column7 like '%test%' or column8 like '%test%' order by column3 > > > > desc; > > > > > > As already stated, the like operator can't use indexes if you use > > > "or", or start with a wild card. > > > > > > Is each '%test%' in your example meant to be the same string, or > > > different strings? If different, then what exactly is each column > > > storing, and what are you trying to search for? Perhaps you could > > > make > > > > > each column more "atomic" by splitting the contents into more > > > columns, > > > > > which you could then search using "=" instead of "like" and so use > > > indexes. > > > > > > Tom > > > BareFeet > > > > > > -- > > > One stop Australian on-line shop for Macs and accessories > > > http://www.tandb.com.au/forsale/?ml > > > > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
