[Yum-devel] sqlite full text search extensions

[Paul Nasrat]

I've built sqlite with load extensions and fts1 and fts2 into rawhide:

http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex

I was wondering if these would be useful for speeding up yum search
behaviour? I don't really have time to benchmark right now but thought
I'd give some pointers:

CREATE VIRTUAL TABLE t USING fts2(pkgKey, name, summary, description);
INSERT INTO t (pkgKey, name, summary, description) SELECT pkgKey, name,
summary, description FROM packages;

SELECT pkgKey, name FROM t WHERE t MATCH "SQL";
163|cyrus-sasl-sql
444|hsqldb
627|mono-data
630|mysql-devel
748|mysql-test
778|velocity
862|mysql
920|qt-sqlite
941|qt-ODBC
1021|qt-MySQL
1124|qt-PostgreSQL
1166|sqlite-devel
1200|libdbi-dbd-sqlite
1288|mysql-bench
1354|openldap-servers-sql
1488|mysql-server
1709|postgresql-server
1717|php-pgsql
1742|postgresql
1934|castor
2113|sqlite


Paul