Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Slow Replication

4 posts in Replication Last posting was on 2009-09-16 19:19:10.0Z
Kiron Joseph Posted on 2009-09-15 12:28:43.0Z
From: Kiron Joseph <kiron@datadevices.com>
Newsgroups: Advantage.Replication
Subject: Slow Replication
Date: Tue, 15 Sep 2009 17:58:43 +0530
Organization: Data Devices Pvt. Ltd.
Reply-To: kiron@datadevices.com
Message-ID: <1p1va5tcdus7s1u9k1di4fubkv57qhtj5r@4ax.com>
X-Newsreader: Forte Agent 3.2/32.830
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 122.172.115.9
X-Trace: 15 Sep 2009 06:27:25 -0700, 122.172.115.9
Lines: 26
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!122.172.115.9
Xref: solutions.advantagedatabase.com Advantage.Replication:372
Article PK: 1134224

Hi All,

I was trying Replication.

Started with DBF with DD

Because of some propblem with DBF with DD Replication,

I changed to ADT with DD

Now problem is Replication with ADT with DD is 30 times slower than
DBF with DD replication. Why ? The problem shows in a tables which has
200000 records.

I tried both in same server and client.

So what are the dependencies which affect Replication Speed ?


I think it is beacuase the deleted records. Other Tables without
deleted records replicating fast.

Please help me urgently.

Regards
Kiron


Peter Funk (ADS) Posted on 2009-09-15 20:04:29.0Z
Date: Tue, 15 Sep 2009 20:04:29 +0000 (UTC)
Message-ID: <864d0bcb197bd8cc0424939f4b8d@devzone.advantagedatabase.com>
From: Peter Funk (ADS) <pfunk@nospam.com>
Subject: Re: Slow Replication
Newsgroups: Advantage.Replication
References: <1p1va5tcdus7s1u9k1di4fubkv57qhtj5r@4ax.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Pro 1098.1
NNTP-Posting-Host: 10.24.38.185
X-Trace: 15 Sep 2009 14:03:08 -0700, 10.24.38.185
Lines: 20
X-Authenticated-User: upreview
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.185
Xref: solutions.advantagedatabase.com Advantage.Replication:375
Article PK: 1134229

Hello Kiron,
If you think that deleted records are the problem, try packing the table
and seeing if it speeds up.

Another thing to look at are the indexes of the ADT table after you converted
it from a DBF. Replication uses SQL to perform the updates and so if the
indexes aren't converted correctly then the SQL engine might not use them
to optimize the updates. Specifically, the concatenation operator (+) behaves
differently with ADI indexes.

If you setup replication to use "all columns" as the row identifier method
then I would recommend adding a primary key index to the table and changing
the publication to use the index rather than all the columns. This can greatly
speed up replication.

Regards,
Peter Funk
Advantage R&D


Kiron Joseph Posted on 2009-09-16 12:37:06.0Z
From: Kiron Joseph <kiron@datadevices.com>
Newsgroups: Advantage.Replication
Subject: Re: Slow Replication
Date: Wed, 16 Sep 2009 18:07:06 +0530
Organization: Data Devices Pvt. Ltd.
Reply-To: kiron@datadevices.com
Message-ID: <khm1b5tqbvhq9eqo9lq23vpsuceftv4al1@4ax.com>
References: <1p1va5tcdus7s1u9k1di4fubkv57qhtj5r@4ax.com> <864d0bcb197bd8cc0424939f4b8d@devzone.advantagedatabase.com>
X-Newsreader: Forte Agent 3.2/32.830
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 122.172.115.9
X-Trace: 16 Sep 2009 06:35:48 -0700, 122.172.115.9
Lines: 52
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!122.172.115.9
Xref: solutions.advantagedatabase.com Advantage.Replication:378
Article PK: 1134232

Hi Peter,

On Tue, 15 Sep 2009 20:04:29 +0000 (UTC), Peter Funk (ADS)

<pfunk@nospam.com> wrote:

>Hello Kiron,
>If you think that deleted records are the problem, try packing the table
>and seeing if it speeds up.

When there is no deleted records its fast as in DBF with DD
>
>Another thing to look at are the indexes of the ADT table after you converted
>it from a DBF. Replication uses SQL to perform the updates and so if the
>indexes aren't converted correctly then the SQL engine might not use them
>to optimize the updates. Specifically, the concatenation operator (+) behaves
>differently with ADI indexes.

Yes. deleted all Indexes and recreated with Data Architect. But no
improvement
>
>If you setup replication to use "all columns" as the row identifier method
>then I would recommend adding a primary key index to the table and changing
>the publication to use the index rather than all the columns. This can greatly
>speed up replication.

Added a primary column. But no improvement.


So I think speed degradation is because of deleted records.

My situation is as follows.

I have a table. and will add records periodically. Later I will delete
the records and reuse it when requires.

You can see this in a table with 50000 records.

What others doing ?

Is there any other alternative other than deleting and reusing it ?

I was under the impression that replication is perfect in ADT with DD
combination.


Regards
Kiron
>
>Regards,
>Peter Funk
>Advantage R&D
>