Thanks for the reply, Todd, but I'm not using GO TOP. I'm using the TOP parameter of the SELECT - SQL statement.
>Go Top is non-optimizable, use locate all instead of go top.
>
>>I think I've discovered an optimization problem with TOP and wondered if I'm missing something obvious here.
>>
>>I'm developing some standard routines that I can use in an app that will use either fox tables or upsized SQL data. Native Fox access returns data at the normal 2-3 times faster than SQL except when I try to use TOP in the SELECT. Then, Fox *crawls*!
>>
>>For example, I am running the same query against a 64,000 record, 120 MB Fox table and the same table after upsizing it to SQL. An index tag for "ship_no" exists in both data sets. I execute the following line:
>>
>>select top 21 * from tship where ship_no >= ?m.ship_no order by ship_no
>>
>>The performance I get is:
>>SQLEXEC() thru SQL Server: 2.956 secs
>>SELECT thru native Fox: 83.727
>>SQLEXEC() thru Fox ODBC: 166.490
>>
>>Has anyone had any experience with this? Any suggestions? Thanks.
Later...
/< /-/