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