>>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. :>)
>
>Yep... Just ran it only selecting 2 fields and it ran in 12 seconds. I think I'm going to use Doug's suggetion of starting out with a limited-field view for the users to select from. Then I'll go on to a full-field, but limited-record view when they choose the one to edit.
>
>Still think it should run faster though...
>
>Renoir

Have you tried issuing a ZAP before running the query ???