Hi Jim

This is across the LAN, strangely enough the system has a webserver attached which is stacks fast than the LAN even over 56K.

Am I correct in assuming that remote views will significantly speed this up???

Regards
Geoff Scott

>A local view will transfer an entire table to the workstation **IF** the the index(es) for the table aren't applicable to the specific view.
>IF the indexes do apply (i.e. they do have the Riushmore effect) then the indexes only will be transferred, then only the applicable records.
>
>What do you mean by "across the network"?... do you mean using dial-up?
>
>good luck
>
>>Hi Liam
>>
>>the amount of records is in most cases less than 10 yet it is taking 20 seconds plus each time.
>>
>>Surely this cannot be normal??? Does a local view transfer the entire table then select its data???
>>
>>Regards
>>Geoff Scott
>>
>>
>>>Hi Dave,
>>>
>>>Executing a view locally will transfer data at around 100MBytes/Sec (depending on your drive/bus). Executing the same view across a network will transfer data at up to 100MBits/Sec.
>>>
>>>
>>>
>>>Regards,
>>>
>>>Liam
>>>
>>>
>>>>Hi
>>>>
>>>>I have a couple of view that take 1-3 seconds when executed locally but are taking 20+ seconds to execute when going across the network.
>>>>
>>>>Can someone explain why this is and how I fix it.
>>>>
>>>>Thanks
>>>>Geoff Scott