I'm curious about the speed trade off between a full table scan and just a flat file search... Say I have a database with 20000 records in it. If I do a query like:
SELECT foo FROM table WHERE bar LIKE '%glaven%'; That will be a full text scan across the table. Would that be any faster than just a regexp against a flat text file? Obviously you get the advantages of SQL were it in a DB, versus a flat file. What other trade offs are there? My experience the above, is that in SQLITE it's still incredibly fast. -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
