Replication - syncronizing most of the data some of the time
Posted
by uncle brad
on Stack Overflow
See other posts from Stack Overflow
or by uncle brad
Published on 2010-04-27T20:31:12Z
Indexed on
2010/04/27
20:33 UTC
Read the original article
Hit count: 293
sql-server
|replication
I have some data that isn't properly "partitioned" (for lack of a better word).
All inserts, processing and reporting happen on the same table. The bulk of the processing happens not long after the insert and not long after that it becomes immutable (we're talking days).
I could do all inserts and processing on a new table that I replicate to the old table. When I detect that the data has become immutable I would delete the data from the new table, but I would edit the delete replication stored procedure so that the delete did not replicate.
How bad an idea is this?
It seems attractive at the moment (I haven't slept on it yet) because it might mitigate a performance problem with only very small changes to the application. It also seems like it might be a good way to shoot myself in the foot.
© Stack Overflow or respective owner