>I have install SQLExpress2008 on a WS2003 with 2 Gb RAM (development machine)
>
>When I run a query against a table with 100.000 records from the Microsoft SQl Server Managent studio:
> [ Select top 1000 from sometable ]
>It returns the results in less than a second.
>
>But when I run the same query from VFP
> [ sqlexec(nHandle, "Select top 1000 from sometable ", "cur") ]
>It takes for ever, more than 15 seconds.
>What is the problem ?

See also message #1413738 (links from it) for some tips of improving performance.