2011/8/8 Simon Slavin <slav...@bigfraud.org>: > You're quite right. If someone was going to write that functionality into a > SQLite app in real life they'd probably use 'LIKE' or 'GLOB' and store all > the possibilities in one row.
FTS3/FTS4 is better as index for lists. See my test script for Igor. We can fast search any id by using "match" operator on FTS table. P.S. FTS table has nice scalability. Check insertion a lot of records and insertion speed is constant. I did try 400 millions of records (and did get database size > 100 Gb). -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users