Could be, I'm hitting a table with 18 fields, 33974 records. In the command window:
sys(3054,1)
open database \\myserver\mydata\lposdata.dbc
set database to lposdata
select * from stylesheet where unitsellprice > 10
after a clean boot. I can't see how a local drive select could be
that much worse.
>Could Ren be selecting a lot of large fields? Would that make the difference?
>
>>I just did a quick SELECT from a table across the network, pulled 17k+ records from >34k on a very non discriminating field. No related index. .95 seconds. Rushmore optimization level for table - none. You do have a problem. :>)