Re: CDR with WorkGroup server.

In article <6s2cou$qoc@drn.newsguy.com>, srkrishna@yahoo.com (Ravi Krishna) wrote: > Hi, > > Here is the scenario. The client wants a centralized database server, > with around 120 users geographically spread all over USA. The users are > connected thru WAN( frame relay), with guaranteed 56 KBPS. The > Application is going to be a 3 tier one, front end (Delphi), and > middleware (Entera) and Informix database server. My concern is the > response time. The client wants a response time of max 5 seconds for > customer support folks which I seriously doubt. The key is to keep your traffic to absolute minimum and therefore use SPL to most of the work. I don't know about 5 seconds but when carrying out tests on an ISDN based system where virtually everything was done in SPL one typical task would take 5 minutes from the PC whereas from a locally connected PC its under 10 seconds and as a pure dbaccess session with the SPL called with hard coded parameter the timex was giving under 0.5 second for usr and sys combined. BTW this was Gupta frontend to Informix > > The application does not require a centralized database. I feel that > each of the 120 office can have a local Informix server running, with > CDR mechanism to the HQ database. This way the response time won't be > a problem and yet folks at HQ can have access to all branch information. > > Questions: - > > 1. Does Workgroup server support CDR? Dynamic server for each office > will be > overkill. Most of the office can easily manage with Workgroup server, > which is lot less expensive. The support costs alone might make 120 remote servers unfeasible. > > 2. Is the feasible to have 120 servers replicating to one server? > > 3. In some case there may be a need of data from one of the branch > office copied to all other branches. If not all branch, certainly some > selected branches. Can this be done efficiently thru CDR? Can't commment on CDR but as central database there wouldn't be the need:-)) > > > Please email me, as I will not be reading this newsgroup often. > > TIA. > > Ravi Krishna. > Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #