473,385 Members | 1,630 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Deletion old data in replication environment

Hi to all

I have a question about deletion of amount of data:

My production environment is this one:
- one publisher with a database (historycal events)
- 50 subscribers with the prev database in unidirectional replication
unidirectional (from subscribers to publisher)

My target was capturing events from the subscribers to send them to
publisher (later I can do reports on it).
Once the data is on the server i don't need them any more in subscribers.

Now I would like to delete the oldest data (year 2003) of some table on the
publisher (remember that replication is unidirectional S->P).

The tables contain about 6-7 millions of records.
I delete one month per time. The process is about 30 minutes long and the
merge agent subscribers changes in retry state.

Can I use these queries to make faster this process? Eventually what kind of
problems can I have ?
DELETE FROM mydb WITH (PAGLOCK) WHERE mydb.dbo.mydate Between date1 and
date2
or
DELETE FROM mydb WITH (ROWLOCK) WHERE mydb.dbo.mydate Between date1 and
date2

Thank you very much for your support.

Marco
Jul 23 '05 #1
0 1064

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Mahesh Hardikar | last post by:
Hello , Oracle 9.0.1.0.0 on HP-UX 11.11 I am testing Procedural Replication in Multimaster Replication Environment. (Asynchronous) Package PACK_1 with a PROC_1 does insert in TAB_1. The...
2
by: Cherrish Vaidiyan | last post by:
Hello, I have certain doubts regarding replication of Oracle 9i in Red Hat Linux 9. 1) I want to implement asynchronous/synchronous multimaster replication.I have heard about Replication...
0
by: Cherrish Vaidiyan | last post by:
Frank <fbortel@nescape.net> wrote in message news:<bqgb99$a04$1@news1.tilbu1.nb.home.nl>... > Cherrish Vaidiyan wrote: > > Hello, > > > > I have certain doubts regarding replication of Oracle 9i ...
3
by: cfxchange | last post by:
I am looking into work-arounds for what seems to be a flaw, or "undocumented feature" of SQL Server replication and Instead of Delete triggers not playing together. It seems that if you want to...
7
by: Unihost Web Hosting | last post by:
Hi All, Firstly I've gotta say that I think that PostgreSQL is one of the finest OSS projects out there and full credit to all of those involved. After talking to a couple of other consultants...
4
by: esmith2112 | last post by:
Having a bear of a time trying to implement replication under 8.2 environment. I've created all of the control structures on both source and target database and can actually see data being staged...
56
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving...
3
by: Gert van der Kooij | last post by:
Hi, Our SQL Replication is between DB2 databases on Windows servers. I'm searching for the document which tells me how to migrate our SQL Replication environment from V8 to V9 (we also need to...
1
by: lltong | last post by:
Hi all, I have 2 databases and both of them have db2 HADR set up. Now I will need to set up the bidirectional Q replication between those 2 databases. Is it a environment supported by db2? I can...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.