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.

Where to partition?

2 posts in General Discussion (old) Last posting was on 2000-02-18 20:49:53.0Z
Jorge Luzarraga C. Posted on 2000-02-11 17:40:35.0Z
Newsgroups: sybase.public.easerver
From: "Jorge Luzarraga C." <jluzarra@alboradasystems.com>
Subject: Where to partition?
Date: Fri, 11 Feb 2000 12:40:35 -0500
Lines: 25
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
NNTP-Posting-Host: 209.170.68.205
Message-ID: <347_EWyOopLd$GA.305@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28885
Article PK: 161258

Hi guys,
I have a really big doubt related to how to partition a three-tier
application and its consequences on the performance.

Let's supposed we have a heavy process that needs to interact with the
database in order to load values to accomplish its job.

What would you do?
1. And stored procedure that does this proccessing and a component that
invokes it and send it the parameters
2. a component that does this proccesing and that uses preallocated
component(shared) that have all the values from the necesary tables to work.

I think, this is about who the best is to manage concurrency, memory.

What is the best answer if we consider performance, scalability and response
time?

Is there any published article about this issue?

Jorge Luzarraga C.
www.alboradasystems.com


Bruce Armstrong [TeamSybase] Posted on 2000-02-18 20:49:53.0Z
Newsgroups: sybase.public.easerver
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Organization: TeamSybase[12.13.238.140]
X-Newsreader: AspNNTP 1.41 (Advent 2000, Inc.)
Subject: Re: Where to partition?
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Fri, 18 Feb 2000 15:49:53 -0500
Lines: 41
NNTP-Posting-Host: 207.156.232.4
Message-ID: <347_LUx20Gle$GA.332@forums.sybase.com>
References: <347_EWyOopLd$GA.305@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28354
Article PK: 160383

My $0.02, I would probably go with 1. The question would be, how often does
this get called? What are the chances that two or more users would end up
running the same process concurrently?

On Fri, 11 Feb 2000 12:40:35 -0500,
in powersoft.public.easerver

Jorge Luzarraga C. <jluzarra@alboradasystems.com> wrote:
>Hi guys,
> I have a really big doubt related to how to partition a three-tier
>application and its consequences on the performance.
>
>Let's supposed we have a heavy process that needs to interact with the
>database in order to load values to accomplish its job.
>
>What would you do?
>1. And stored procedure that does this proccessing and a component that
>invokes it and send it the parameters
>2. a component that does this proccesing and that uses preallocated
>component(shared) that have all the values from the necesary tables to work.
>
>I think, this is about who the best is to manage concurrency, memory.
>
>What is the best answer if we consider performance, scalability and response
>time?
>
>Is there any published article about this issue?
>
>Jorge Luzarraga C.
>www.alboradasystems.com
>
>
>

---
Bruce Armstrong [TeamSybase] | kforce.com
mailto:Bruce.Armstrong@teamsybase.com | http://www.kforce.com

Preach the gospel at all times. If necessary, use words. [Francis of Assisi]
http://www.kidbrothers.org | http://www.fccwc.org
http://www.harvest.org/knowgod/index.htm | http://www.needhim.org

-----------== Posted via the PFCGuide Web Newsreader ==----------
http://www.pfcguide.com/_newsgroups/group_list.asp