Re: Witango-Talk: database on another server

Wed, 29 Oct 2003 18:32:49 -0800

My experience on Windows 2K and Tango 2000 is that there are large performance benefits by having the database on a different box. I have noticed this with environments other than Witango as well... When we deployed our classified ad system originally on Windows it had many performance issues. It would not function well on one server and occasionally hogged the cpu causing a Document contains no data error. Lots has changed since 2000...

On Oct 29, 2003, at 5:43 PM, Fogelson, Steve wrote:

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



________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

Reply via email to