Subject Re: running SQL LIKE % on DBF table
From WJS <wara@nowhere.com>
Date Fri, 31 Jul 2015 23:04:44 +0200
Newsgroups dbase.getting-started

On 2015-07-31 06:29 PM, eric wu wrote:
>
> "select Myame from myTable where name like 'ABC%'"
>
> myTable.dbf is a 80MB file
> it takes 20 mins.  to get the result.
>
> is it normal ?
>
> or I should index the filed "Myame"  to improve the performance ?
>
> eric

I would say it is not normal.
I do a similar thing on a 356MB dbf and it takes 8 sec when run for the
first time. 2 sec there after
The table have a simple index on the field

Wian