RE: Witango-Talk: database on another server

[Fogelson, Steve]

Hi,   Does splitting the db to another server save resources on the Witango server?   I would assume it saves disk reads, but would it save cpu usage? For example , if the search action has "ordered by" columns or a join?   I don't know anything about ODBC. Not sure if the DB engine is part of OBDC.   Is there a way to locate the DB Engine on the second server to move that processing to the 2nd server?   What is the tradeoff of having to transmit the results back to the web and Witango server assuming over the network?   Sorry for the questions, but I have always wondered what are the benefits and drawbacks of moving the db to another server and is there a better way to do it.   Thanks   Steve Fogelson Internet Commerce Solutions      -----Original Message----- From: Jan Magnusson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 5:07 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: database on another server Hi Alan,   Maybe I misunderstood the question, but if you are going to have WiTango on one server and the db on another then just (re)configure the ODBC System DSN drivers on the WiTango server to point to the distant db server.   The Witango service doesn't know where the database physically resides, just which ODBC connection to use.   And if you use the exact same name, uid and pwd for the new odbc connection you should not even have to touch the Witango server, service or taf files. Things get a lot more complicated if you don't use the same name, then all the tafs need to be edited/updated.   I don't know if there are some r:tango specific additional complicating matters, but this should work if it's now configured on an ODBC connection.   Jan -----Original Message----- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 00:32 To: [EMAIL PROTECTED] Subject: Witango-Talk: database on another server how would you go about setting up a datasource that was on another server from where the datasource was being used by a .taf?   i have no idea where to even begin looking for information on this one! (:   we're using r:tango 5 on windows 2003 and the database is going to be on an NT 4 machine which has r:tango 2000 on it (so both sides have oterro if that matters).   We're trying to set up an experiment to see how realistic it would be to have a database on another computer across the internet (im guessing not very realistic but maybe for limited usage it would work?)   Thanks! Alan ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf