i don't think 'top 10' is optimizable in vfp.


>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