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.

ASA Scalability

2 posts in General Discussion Last posting was on 2002-11-05 14:05:53.0Z
Rajnikant Puranik Posted on 2002-11-05 09:39:43.0Z
From: "Rajnikant Puranik" <rkpuranik@vsnl.com>
Subject: ASA Scalability
Date: Tue, 5 Nov 2002 15:09:43 +0530
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <dLoM7FLhCHA.329@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 203.197.43.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:466
Article PK: 2287

We have a banking application, with ASA (Sybase Adaptive Server Anywhere 8)
as backend and PowerBuilder as frontend. It is running in a
distributed/decentralised set up - one database per branch (total 59
locations) - linked over WAN. Data is aggregated/piped (through an automated
utility) monthly into a centralised off-line ASA database (whose structure
is same as that at branches) for MIS and other purposes.

We now plan to have an on-line centralised database only, dispensing with
databases at branches. Our current database structure supports it. The size
of the proposed centralised database is likely to grow to 50 GB within a
year, and the size is likely to be around 100 GB (with periodic truncation).
The total number of simultaneous users would be around 1000, and may grow to
2000.

What I would like to know is whether it is advisable to continue with ASA
for centralised database too. We are obviously interested in continuing with
it because (a)the application is very robust and very stable (practically
maintenance free), thanks to ASA and PowerBuilder, and also quality of
design and coding, and (b)we would like to avoid massive re-coding or
modifications that would need to be made for an alternate platform. Of
course, we do need to make modifications for centralised setup on the
current platform too - but those would be relatively much less.

However, what if it fails to work? That would be very embarassing - doing
all the modifications on existing platform of ASA (there are a large number
of T-SQL stored procedures and triggers) and PowerBuilder, and it failing to
deliver.

Is ASE more scalable than ASA? If so, what are the specific technical
reasons that make ASE so?

I shall be very thankful to have your advice in the matter.

Thanks and Regards,

-Rajnikant Puranik

rkpuranik@vsnl.com


Robert Waywell Posted on 2002-11-05 14:05:53.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <dLoM7FLhCHA.329@forums.sybase.com>
Subject: Re: ASA Scalability
Date: Tue, 5 Nov 2002 09:05:53 -0500
Lines: 81
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <#KlVlaNhCHA.329@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:465
Article PK: 2282

I'd suggest searching the newsgroup sybase.public.sqlanywhere.general. There
are several threads in that newsgroup that discuss scalability. You may also
want to contact an iAnywhere sales rep/account manager who should be able to
provide you with reference customers that fit your requirements.

--
-----------------------------------------------
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://casexpress.sybase.com/cx/cx.stm

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

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Rajnikant Puranik" <rkpuranik@vsnl.com> wrote in message
news:dLoM7FLhCHA.329@forums.sybase.com...
> We have a banking application, with ASA (Sybase Adaptive Server Anywhere
8)
> as backend and PowerBuilder as frontend. It is running in a
> distributed/decentralised set up - one database per branch (total 59
> locations) - linked over WAN. Data is aggregated/piped (through an
automated
> utility) monthly into a centralised off-line ASA database (whose structure
> is same as that at branches) for MIS and other purposes.
>
> We now plan to have an on-line centralised database only, dispensing with
> databases at branches. Our current database structure supports it. The
size
> of the proposed centralised database is likely to grow to 50 GB within a
> year, and the size is likely to be around 100 GB (with periodic
truncation).
> The total number of simultaneous users would be around 1000, and may grow
to
> 2000.
>
> What I would like to know is whether it is advisable to continue with ASA
> for centralised database too. We are obviously interested in continuing
with
> it because (a)the application is very robust and very stable (practically
> maintenance free), thanks to ASA and PowerBuilder, and also quality of
> design and coding, and (b)we would like to avoid massive re-coding or
> modifications that would need to be made for an alternate platform. Of
> course, we do need to make modifications for centralised setup on the
> current platform too - but those would be relatively much less.
>
> However, what if it fails to work? That would be very embarassing - doing
> all the modifications on existing platform of ASA (there are a large
number
> of T-SQL stored procedures and triggers) and PowerBuilder, and it failing
to
> deliver.
>
> Is ASE more scalable than ASA? If so, what are the specific technical
> reasons that make ASE so?
>
> I shall be very thankful to have your advice in the matter.
>
> Thanks and Regards,
>
> -Rajnikant Puranik
>
> rkpuranik@vsnl.com
>
>
>
>
>