Any chance of virus software interference on the workstation?

I don't see why a remote view would speed it up.

>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