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 _______________________________________________ Yum-devel mailing list [email protected] https://lists.dulug.duke.edu/mailman/listinfo/yum-devel
