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.

Proxy tables

2 posts in General Discussion Last posting was on 2009-06-28 14:00:59.0Z
Chuck Posted on 2009-06-22 15:22:21.0Z
Sender: 7f52.4a3f9bdf.1804289383@sybase.com
From: Chuck
Newsgroups: sybase.public.ase.general
Subject: Proxy tables
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a3fa1ad.4b3.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 22 Jun 2009 08:22:21 -0700
X-Trace: forums-3-dub.sybase.com 1245684141 10.22.241.188 (22 Jun 2009 08:22:21 -0700)
X-Original-Trace: 22 Jun 2009 08:22:21 -0700, forums-3-dub.sybase.com
Lines: 44
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27898
Article PK: 77148

I have a situation where I have a vendor supplied solution
for data archiving.

Briefly, what the process does is move data from one
database to another (same server) maintaining DB Integrity .
Before moving, it has its own business specific
edits/validations in place.

Some of the code uses stored procedures and sometimes its an
inline query, we only have a binary (don't have source code
of product to make any changes).

The solution proposed by the Vendor is to create an archive
database in the same server. To provide adequate recovery
options, I am thinking that the archive database should be
on a seperate low cost server. So, I have the following
questions on using proxy tables.


Solution:

1. ServerA has following databases:
sybdev
sybdevar

2. ServerB has the following databases
sybdevar

ServerA, sybdevar holds proxy table (with same name,
columm structures as ServerB, sybdevar).ServerB holds
actual tables & data after its been archived

1. How does a DML statement work on a proxy table ?
Will a insert on a proxy table (serverA) insert directly
into ServerB tables.

2. Performance on DML.
Assuming(1) works, Is there significant difference on
inserting into a proxy table vs regular table. Are there any
numbers on how much more time proxy table takes (compared to
a regular table).

Thank you
Chuck


Cory Sane [TeamSybase] Posted on 2009-06-28 14:00:59.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4a3fa1ad.4b3.1681692777@sybase.com>
In-Reply-To: <4a3fa1ad.4b3.1681692777@sybase.com>
Subject: Re: Proxy tables
Lines: 57
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a47779b$3@forums-3-dub.sybase.com>
Date: 28 Jun 2009 07:00:59 -0700
X-Trace: forums-3-dub.sybase.com 1246197659 10.22.241.152 (28 Jun 2009 07:00:59 -0700)
X-Original-Trace: 28 Jun 2009 07:00:59 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27926
Article PK: 77176

Chuck,
You have a very good idea.

Performance, will differ with a proxy table... I can only suggest that you run a few tests to see if the proxy tables will meet
your speed needs.


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Chuck" wrote in message news:4a3fa1ad.4b3.1681692777@sybase.com...
>I have a situation where I have a vendor supplied solution
> for data archiving.
>
> Briefly, what the process does is move data from one
> database to another (same server) maintaining DB Integrity .
> Before moving, it has its own business specific
> edits/validations in place.
>
> Some of the code uses stored procedures and sometimes its an
> inline query, we only have a binary (don't have source code
> of product to make any changes).
>
> The solution proposed by the Vendor is to create an archive
> database in the same server. To provide adequate recovery
> options, I am thinking that the archive database should be
> on a seperate low cost server. So, I have the following
> questions on using proxy tables.
>
>
> Solution:
>
> 1. ServerA has following databases:
> sybdev
> sybdevar
>
> 2. ServerB has the following databases
> sybdevar
>
> ServerA, sybdevar holds proxy table (with same name,
> columm structures as ServerB, sybdevar).ServerB holds
> actual tables & data after its been archived
>
> 1. How does a DML statement work on a proxy table ?
> Will a insert on a proxy table (serverA) insert directly
> into ServerB tables.
>
> 2. Performance on DML.
> Assuming(1) works, Is there significant difference on
> inserting into a proxy table vs regular table. Are there any
> numbers on how much more time proxy table takes (compared to
> a regular table).
>
> Thank you
> Chuck