Oterro is what performs the querry and it would be running on the web server's cpu and you would be using the disk access from the db server.
I am not really sure if you will improve performance. I think it will be a trade off because now you have network issues involved between the database and the web server. I would make this determination by asking the question "Are other R:base users going to be using the database?" If yes, I would put the database on a DB server. If just the web server is accessing that db for the most part, I would leave the db on the web server. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Fogelson, Steve Sent: Friday, September 19, 2003 10:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: R:Tango Installation - Razzak's Reply >From the responses from Troy and Razzack, it appears that Tango and Oterro are installed on the web server. Not quite sure how to ask this. When a query is performed via the web (Tango) on the database (assuming the db is on a different server), which server's cpu is processing db query? I had assumed that by putting the db on a separate server, that it would take the db query load from the web server and place it with the db server. Thus spreading the load on the servers. But with Oterro on the web server, is this happening? Steve -----Original Message----- From: A. Razzak Memon [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 9:19 AM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: R:Tango Installation - Razzak's Reply At 08:42 AM 9/19/2003 -0500, Steve Folgelson wrote: >I have heard it is more efficient to break a R:Tango installation into 2 >servers. One for serving web pages and one for the database processing. Not >sure if R:Tango should be installed on the web or DB server. > >Basically I am looking for step by step instructions on how to do this. Steve, Typically, R:Tango 2000 or R:Tango 5.0 is installed on the WEB Server running MS IIS configured with Oterro 2.6 or 3.0 System DSNs. You have the option to keep your corporate R:BASE database on either the same WEB Server or any other Network Servers as long as the appropriate DSNs are configured. Either way, you should have no problem. Hope that helps! Very Best R:egards, Razzak.
