>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