in reply to how to speed up pattern match between two files

upload your entire 2GB file into local db mysql
and do select * from table where col1 = 'a' and col2 = 'b';
  • Comment on Re: how to speed up pattern match between two files