[sqlite] will FTS speed up [LIKE '%foo%'] searches? or: how does iTunes do it?

iTunes has "update search results as you type" speed even when you have a hundred thousand songs and you're searching on a partial string on all meta data columns. how on earth do they do that? i'm under the impression it uses CoreData, which in turn uses SQLite under the hood. how can i

Re: [sqlite] FTS slowdown with matchinfo

On 02/16/2011 12:50 AM, Iker Arizmendi wrote: > Hello all, > > I'm running into what seems like an abnormally large > performance drop on on some FTS queries that use > matchinfo when compared to those that don't. > > I created an FTS table using the following: > > CREATE VIRTUAL TABLE test >

Re: [sqlite] BUG: test script exclusive2.test needs do_not_use_codec

Thanks. I think I got all the changes. On Mon, Feb 14, 2011 at 7:47 PM, Noah Hart wrote: > > exclusive2.test reads directly from the database using binary read > > It needs the following changes: > > -source $testdir/tester.tcl > +source $testdir/tester.tcl > + > +# Do not

Re: [sqlite] Speed up count(distinct col)

> IMDb Pro offers additional information and services, all the information I > am grabbing is already available to the public and I am not publishing this > information, there are a lot of programs that do this. OK, good to know, thanks. >>> The script is written in bash and I can give you the

Re: [sqlite] Composite primary key with autoincrement

On 15 Feb 2011, at 11:28pm, Drake Wilson wrote: > Quoth Maciej Lotkowski , on 2011-02-15 23:28:01 > +0100: >> Is it possible to have composite primary key where one column is >> autoincrement? From what I found in docs it looks like it is possible >> to have either

Re: [sqlite] Composite primary key with autoincrement

Quoth Maciej Lotkowski , on 2011-02-15 23:28:01 +0100: > Is it possible to have composite primary key where one column is > autoincrement? From what I found in docs it looks like it is possible > to have either simple primary key on one autoincrement column or >

Re: [sqlite] Sqlite .NET 4.0 provider available?

On 15 Feb 2011, at 8:31pm, Matthew Adams wrote: > I'm a bit confused with the current level of support for Sqlite on > .NET. I've seen both http://sqlite.phxsoftware.com and > http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki, > explaining that the codebase is under transition.

Re: [sqlite] Speed up count(distinct col)

BareFeetWare-2 wrote: > > Does IMDB allow use of their data this way? After my brief reading of > their site, I thought they charge a $15k minimum per year for data. > IMDb Pro offers additional information and services, all the information I am grabbing is already available to the public and

[sqlite] Composite primary key with autoincrement

Hi Is it possible to have composite primary key where one column is autoincrement? From what I found in docs it looks like it is possible to have either simple primary key on one autoincrement column or composite PK on few columns without autoincrement. Am I right? If no, what is the syntax to

[sqlite] Sqlite .NET 4.0 provider available?

Hi all, I'm a bit confused with the current level of support for Sqlite on .NET. I've seen both http://sqlite.phxsoftware.com and http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki, explaining that the codebase is under transition. If I'm using Sqlite 3.7.5, can I use the last

[sqlite] FTS slowdown with matchinfo

Hello all, I'm running into what seems like an abnormally large performance drop on on some FTS queries that use matchinfo when compared to those that don't. I created an FTS table using the following: CREATE VIRTUAL TABLE test USING FTS4(rowid, content); and then filled it with ~2

[sqlite] [documentation] very minor docs bug

http://sqlite.org/features.html "Database For Gadgets. SQLite is popular choice for the ..." should have an article, like "Database For Gadgets. SQLite is a popular choice for the ..." Eric -- Eric A. Smith Windows is *NOT* a virus - viruses are small and efficient.

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

On Tue, 15 Feb 2011 03:30:23 -0800 (PST), venkat easwar wrote: >Oh... Thanks Kennedy. Between any options on run time to enable the feature? No, it's a compile-time option, compiling without SQLITE_ENABLE_UPDATE_DELETE_LIMIT makes SQLite a bit lighter. Without that

Re: [sqlite] UPDATE/INSERTing 1-2k rows slower than expected

I'll give you another failure point that most people never see or think of. I used to manage numerous Linux systems with RAID-5. One time I had a drive fail, the spare kicked in, and then during the rebuild a 2nd drive failed...hosing the RAID (i.e. two failed disks). The problem was...normal

[sqlite] Scrolling through results of select

Hi all, I'm looking for the best way to scroll through data returned by an arbitrary select statement. That is, I want something that will work for any SQL select statement string I throw at it at runtime. I've looked through: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor and a few

Re: [sqlite] bug in older version of sqlite

Dustin J. Mitchell wrote: > def combined(): >conn1 = sqlite3.connect("/tmp/my.db") >curs1 = conn1.cursor() >print "1: pragma" ## B >curs1.execute("PRAGMA table_info('foo')") > >conn2 = sqlite3.connect("/tmp/my.db") >curs2 =

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

Oh... Thanks Kennedy. Between any options on run time to enable the feature? VENKAT From: Dan Kennedy To: sqlite-users@sqlite.org Sent: Tue, February 15, 2011 4:48:24 PM Subject: Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR On

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

On 02/15/2011 06:04 PM, venkat easwar wrote: > Forgot to mention what error I am getting. > > near "order": syntax error > near "limit": syntax error - if i remove the order by clause See under the "Optional LIMIT and ORDER BY Clauses" heading on this page:

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

I apologize for multiple mails. In create I missed to add one column. The actual create statement is create table check_update( a int, b char, c int); insert into check_update values (1,'venkat',22); insert into check_update values (2,'venkat',23); Failing query: update check_update set

Re: [sqlite] UPDATE WITH ORDER BY LIMIT ERROR

Forgot to mention what error I am getting. near "order": syntax error near "limit": syntax error - if i remove the order by clause VENKAT From: venkat easwar To: General Discussion of SQLite Database Sent:

[sqlite] UPDATE WITH ORDER BY LIMIT ERROR

Hi Buddies, Sqlite support document says, update with limit and order by clauses are supported. But I found it actually not working. Sample DB schema, create table check_update( a int, b char); insert into check_update values (1,'venkat',22); insert into check_update values (2,'venkat',23);

[sqlite] bug in older version of sqlite

I ran into some odd behavior from older versions of SQLite, and I wonder if anyone can add some details and help me find a good workaround. The details are at http://trac.buildbot.net/ticket/1810. With apologies for boiling this down to Python: import os import sqlite3 print "sqlite.py:",

Re: [sqlite] SQLite version 3.7.5

Any news on System.Data.SQLite.org ? It was a so great news! When are the releases planned? Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users