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.

DbRemote vs Mobilink

3 posts in General Discussion Last posting was on 2007-10-10 13:46:21.0Z
Herman Miller Posted on 2007-10-10 11:02:13.0Z
Sender: 851.470cb033.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: DbRemote vs Mobilink
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470cb135.98d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Oct 2007 04:02:13 -0700
X-Trace: forums-1-dub 1192014133 10.22.241.41 (10 Oct 2007 04:02:13 -0700)
X-Original-Trace: 10 Oct 2007 04:02:13 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6376
Article PK: 2860

We have both DbRemote and Mobilink setup. On the DbRemote
side we have 30 clients sending data to a consolidated
database. The database size is approx 3gb with a page size
of 8192. On the Mobilink side we have 9 clients sending data
to a different consolidated datase. The database size is
approx 10gb with a page size of 8192. The tables and columns
are the same if not less on the mobilink side. Why would the
mobilink database be so much larger?


"Stephen Rice" Posted on 2007-10-10 13:31:51.0Z
From: "Stephen Rice" <srice[at]sybase[dot]com>
Newsgroups: ianywhere.public.general
References: <470cb135.98d.1681692777@sybase.com>
Subject: Re: DbRemote vs Mobilink
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: srice-pciii.sybase.com
X-Original-NNTP-Posting-Host: srice-pciii.sybase.com
Message-ID: <470cd447$1@forums-1-dub>
Date: 10 Oct 2007 06:31:51 -0700
X-Trace: forums-1-dub 1192023111 10.25.98.226 (10 Oct 2007 06:31:51 -0700)
X-Original-Trace: 10 Oct 2007 06:31:51 -0700, srice-pciii.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6379
Article PK: 2863

My first guess is fragmentation. dbinfo will give you an idea of how
"empty" your databae pages are

--
/steve
Stephen Rice
Sybase iAnywhere

<Herman Miller> wrote in message news:470cb135.98d.1681692777@sybase.com...
> We have both DbRemote and Mobilink setup. On the DbRemote
> side we have 30 clients sending data to a consolidated
> database. The database size is approx 3gb with a page size
> of 8192. On the Mobilink side we have 9 clients sending data
> to a different consolidated datase. The database size is
> approx 10gb with a page size of 8192. The tables and columns
> are the same if not less on the mobilink side. Why would the
> mobilink database be so much larger?


Rob Waywell Posted on 2007-10-10 13:46:21.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <470cb135.98d.1681692777@sybase.com> <470cd447$1@forums-1-dub>
Subject: Re: DbRemote vs Mobilink
Lines: 58
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <470cd7ad$1@forums-1-dub>
Date: 10 Oct 2007 06:46:21 -0700
X-Trace: forums-1-dub 1192023981 10.25.98.235 (10 Oct 2007 06:46:21 -0700)
X-Original-Trace: 10 Oct 2007 06:46:21 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6380
Article PK: 2862

Since they are different databases, with different table structures, why do
you expect the data volume to be comparable between the 2 systems?

If you create 2 databases - one with 10 tables and a second with only 1
table, but you then insert 10 records into each of the 10 tables in the
first database and insert 1 million records into the 1 table in the 2nd
database, then the 2nd database will almost undoubtedly be larger than the
first one. Obviously this example is an exaggeration, but your post
certainly seems to indicate that the 2 databases are not identical in
structure which raises the probability that the usage and data volume will
be completely unrelated to each other. If you want to make a meaningful
comparison of data size, then you need to start with identical databases,
run the same data generation scripts on each of the dbremote and MobiLink
systems and then compare the resulting size.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Stephen Rice" <srice[at]sybase[dot]com> wrote in message
news:470cd447$1@forums-1-dub...
> My first guess is fragmentation. dbinfo will give you an idea of how
> "empty" your databae pages are
>
> --
> /steve
> Stephen Rice
> Sybase iAnywhere
>
> <Herman Miller> wrote in message
> news:470cb135.98d.1681692777@sybase.com...
>> We have both DbRemote and Mobilink setup. On the DbRemote
>> side we have 30 clients sending data to a consolidated
>> database. The database size is approx 3gb with a page size
>> of 8192. On the Mobilink side we have 9 clients sending data
>> to a different consolidated datase. The database size is
>> approx 10gb with a page size of 8192. The tables and columns
>> are the same if not less on the mobilink side. Why would the
>> mobilink database be so much larger?
>
>