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 2 records in it. If I do
a query like:
SELECT foo FROM table WHERE bar LIKE '%glaven%';
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 2 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
On 4/29/08, Scott Baker [EMAIL PROTECTED] 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 2 records in it. If I do
a query like:
SELECT foo FROM table WHERE bar LIKE '%glaven%';
That will be a full text