Yes, I was planning on using objects and thought about using first subscript as identifier of the site. I then can define my own storage map and so on. Denver, do you suggest then to link remote databases from different sites to one namespace and do subscript-level mapping of the same global between namespaces and add a site/center ID as one of the properties to each class I create? This might work well, I guess.
What about performace then? If I do a search on local server I will proably do like (I am using SQL for simplicity) select * from table where siteID=localSiteID 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? Will Cache' have local replicas of remote globals ? Thanks. "Denver Braughler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Yuriy Toropov wrote: > > Patient is mostly seen on the site closest to his home. Sometimes he goes > > on a business trip and needs to visit a doctor some other place/site. > > When he visits this other site, they need to have access to his medical > > history, stored on server at home. Please note, that replication of all data > > stored on > > server at home to the remote site server is best avoided and sites should be > > mostly independent. > > > > Is it possble to accomplish this, and if so how, using capabilities of > > Cache 5 alone? > > Yes, network all your computers together and use global mapping with the > medical center ID as the first subscript of every global. > > Are you using objects?
