Hi,

I use the command "select * from client where client.name = 'M' top 10" when client
is a DBF table, it works but it takes long time to return. If I don't use "top 10",
it is very fast.

If the table is in SQL-Server, and i use sqlexec('set rowcount to 10') and the
select it is very fast.

Why this command in the DBF table is worse than in SQL-server ?
I want to have (top 10) in DBF, is there another manner to have this with a good
performance ?

Thanks,

Marcelo Ris