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
|
|