Yuriy Toropov wrote: > Denver, It's better to leave your question open to anyone to answer.
> what if I need to search all other servers? Is it going to be a significant > performance hit if I have 10 servers and have to do this query over network > 10 times? That depends mainly on how fast your network is. > Will Cache' have local replicas of remote globals ? After the first pass, yes, they may be cached. But search is a different beast than accessing the occasional patient who is away from his home center. For just one remote patient, the performance appears nearly equal. For a brute force query (table scan), it could be better to launch the query on the remote server especially if far more records are searched than are selected.
