Run a trial, but I am sure that fgrep will be faster. Scott Baker wrote: > 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. >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
