What’s new in Sync Services for ADO.NET 2.0?

re: What’s new in Sync Services for ADO.NET 2.0?

SYNC IS VERY VERY SLOW — Mon, 30 May 2011 13:51:49 GMT

Dear All,

SYNC IS VERY VERY SLOW (With batching) using bidirectional by terminal

I have implemented batching from syncguru website, now it is working fine, but it takes a long time to complete the process. "Demo VIII: Offline Application - Batching"

the link is www.syncguru.com/.../SyncServicesDemoBatching.aspx

Total records in my table : 60,000 records

BatchSize : 3000

Total Duration : For updating 1000 records, it takes more than 90 seconds

i need to reduce the "Total Duration" upto 30 seconds atleast.

Please provide your valuable suggestions.

Thanks in advance.

regards

yesu

yesudassmca@gmail.com

-- ***********************************************

-- NewAnchor proc with batching support

-- ***********************************************

create procedure [dbo].[sp_new_batch_anchor] (

@sync_last_received_anchor bigint ,

@sync_batch_size int,

@sync_max_received_anchor bigint output,

@sync_new_received_anchor bigint output,

@sync_batch_count int output)

if @sync_batch_size <= 0 or @sync_batch_size is null

set @sync_batch_size = 3000

if @sync_max_received_anchor is null

set @sync_max_received_anchor = min_active_rowversion()-1 -- @@DBTS --min_active_rowversion()-1

-- simplest form of batching

if @sync_last_received_anchor is null or @sync_last_received_anchor = 0

begin

set @sync_new_received_anchor = @sync_batch_size

if @sync_batch_count <= 0 or @sync_batch_count is null

set @sync_batch_count = (@sync_max_received_anchor / @sync_batch_size) + 1

end

else

begin

set @sync_new_received_anchor = @sync_last_received_anchor + @sync_batch_size

if @sync_batch_count <= 0 or @sync_batch_count is null

set @sync_batch_count = (@sync_max_received_anchor / @sync_batch_size) - (@sync_new_received_anchor / @sync_batch_size) + 1

end

-- check if this is the last batch

if @sync_new_received_anchor >= @sync_max_received_anchor

begin

set @sync_new_received_anchor = @sync_max_received_anchor

if @sync_batch_count <= 0 or @sync_batch_count is null

set @sync_batch_count = 1

end

re: What’s new in Sync Services for ADO.NET 2.0?

MSDNArchive — Sun, 03 Feb 2008 21:16:08 GMT

Hi englewood,

Using SQL Change tracking with Peer Provider is not as straight forward at this point. For one, you cannot edit SQL Change Tracking metadata thus you cannot really write Update or Delete metadata commands. That said, there are other ways to do this. The sync team should post some details on how to get this done.

Thanks,

Rafik

re: What’s new in Sync Services for ADO.NET 2.0?

Udai — Wed, 30 Jan 2008 02:05:32 GMT

How to we use DbPeerSyncProvider with SQL Server 2008 change tracking. I would like to bind all the adapter column property into changetable columns.

Sync Services for ADO.NET 2.0

Vinod Kumar's Blog — Fri, 04 Jan 2008 12:26:13 GMT

Check the post on whatz new on Sync Services 2.0 version here.

re: What’s new in Sync Services for ADO.NET 2.0?

MSDNArchive — Mon, 17 Dec 2007 21:22:58 GMT

Hi Vince,

The samples in this directory are the one you want to look into. These are the ones I wrote with my team. You should not need to change the code at all. I did install CTP1 on a clean machine and then compiled the sample which worked just fine. Try to uninstall exiting stuff first and I will look into this from my side.

Thanks!

Rafik

re: What’s new in Sync Services for ADO.NET 2.0?

VinceX.NET — Mon, 17 Dec 2007 20:24:14 GMT

Hi Rafik,

Just a question: I'm struggling to play with CTP1 bits; all samples included inside "C:\Program Files\Microsoft Sync Framework\v1.0\Runtime\ADO.NET\V2.0\Samples] still use version 1.0 of Microsoft.Synchronization.Data.dll and a lot of code must be changed to make it work.

I want to create a synchro layer for my application but I need a sample to start correctly.

Do you have one good sample which use the new CTP1 bits ?

Thxs

Regards

-Vince

re: What’s new in Sync Services for ADO.NET 2.0?

jgilkey — Mon, 17 Dec 2007 19:01:50 GMT

Thank you! Been waiting for this for a while :)