x

Is jumping across servers necessarily a bad programming practice?

I have a system created that a user at one of our other locations and on their server inserts a record. That data is then replicated to a central server. Users working on the central server are allowed to edit that record which means I have to lock the editing capabilities at the location the record was created.

However, i would like the creator of the record to be able to edit it so I am thinking about redirecting them across servers to edit the record on the central server. IS that bad practice and why??

The reason I only allow editing on one of the copies of the record is to prevent it from being copied over in replication.....

WE are also considering Bi-directional replication.

more ▼

asked Feb 23, 2010 at 03:36 PM in Default

avatar image

Eric
23 2 1 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

It does sound like merge replication might work well for you.

To answer your initial question, I'd say ... it depends! Seriously though, here are my thoughts regarding editing data on the central server:

Pros:

  • single set of data
  • easier maintenance (no synchronizing necessary)

Cons:

  • potentially worse performance if central server is far away, has a slower connection or is already overloaded with users/processes
  • A single query joining tables between servers can often be a source of performance issues.

If your central server is local, you might not have any performance issues. I recommend trying some queries and compare performance results from each server.

more ▼

answered Feb 23, 2010 at 04:08 PM

avatar image

Tom Staab ♦
14.5k 7 14 21

It depends = instant +1

Feb 23, 2010 at 06:14 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2022
x1084
x377
x11

asked: Feb 23, 2010 at 03:36 PM

Seen: 1553 times

Last Updated: Feb 23, 2010 at 03:36 PM

Copyright 2017 Redgate Software. Privacy Policy