Re: database and app server separated by WAN

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: vi (none_at_yahoo.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 07:32:22 +0530

We generally keep SQL statements on the application server. For each
transaction the application server will typically send multiple SQL
statements to the database. The database will respond with the answer to the
SQL query. For each transaction the communication occurs multiple times.

When a application server communicates with another application server, I
can ensure that only the necessary parameters are passed once. The results
are sent back once. So communication occur only once for every transaction.

Now you be the judge.
Will multiple transmission of information over WAN be slower or single
transmission?
Vi.

Relevant Pages

  • Re: Why is my _SERV_log.ldf file so big?
    ... take a look at the configuration in Enterprise Manager for your server. ... It's either on the server or on the databases themselves. ... you're doing then you should get your DBA to help with the SQL config. ... >> transaction log is turned on is to let it grow forever. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: MSDE on flash memory
    ... Therefore you may end up corrupting the transaction log in top level but still have some "old" ... I was wondering if it is considerable for you to move the DB on a server? ... I don't think MSDE has any "embedded" specific integration including flash random writing or etc. Keep in mind that MSDE on XPE ... I don't think SQL CE has any flash related issues fixed either. ...
    (microsoft.public.windowsxp.embedded)
  • Re: SqlTransactions and Sql timeout errors
    ... Basically the way transactions work in SQL Server is that the first ... commit the transaction. ... In committing the transaction, the server ... For example, if an Update statement fails in a batch, then SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: sql server i/o bottle neck ?
    ... My first guess is that you might be committing each SQL ... to perform many more transaction log writes. ... I'm not a java guy. ... On SQL Server the default behaviour is that each statement is a separate ...
    (comp.databases.ms-sqlserver)
  • Re: computational model of transactions
    ... conversations from years past about "multiple assignment". ... have to be only updates. ... problem that can not be dealt with simplyistic SQL based solutions. ... one still sees prior updates within the transaction. ...
    (comp.databases.theory)