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.

PBL size + Max object

3 posts in General Discussion (French) Last posting was on 2010-04-07 13:26:56.0Z
Linto Thomas Posted on 2008-06-10 06:20:16.0Z
Sender: 2c2b.484e1b36.1804289383@sybase.com
From: Linto Thomas
Newsgroups: sybase.public.powerbuilder.french.general
Subject: PBL size + Max object
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <484e1d20.2c74.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2008 23:20:16 -0700
X-Trace: forums-1-dub 1213078816 10.22.241.41 (9 Jun 2008 23:20:16 -0700)
X-Original-Trace: 9 Jun 2008 23:20:16 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.french.general:19
Article PK: 424921

Hi
I would like to know the following
1, Maximum number of objects that a PBL can Hold ?
2, Maximum size of a PBL ?
3, Which combination of above give me maximum perfomance ?
4, Where can I find useful information regarding this ?
I will be very much thankful for the one who can provide me
complete INFORMATION ? I would like to get above information
from a trusty place; so that I can implement with out any
breach... :-)


Bruce Armstrong [TeamSybase] Posted on 2008-06-10 16:58:22.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.french.general
References: <484e1d20.2c74.1681692777@sybase.com>
Subject: Re: PBL size + Max object
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484eb2ae$1@forums-1-dub>
Date: 10 Jun 2008 09:58:22 -0700
X-Trace: forums-1-dub 1213117102 10.22.241.152 (10 Jun 2008 09:58:22 -0700)
X-Original-Trace: 10 Jun 2008 09:58:22 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.french.general:21
Article PK: 424926

Since you're posting in English, why not post in one of the English speaking
sections?

<Linto Thomas> wrote in message news:484e1d20.2c74.1681692777@sybase.com...
> Hi
> I would like to know the following
> 1, Maximum number of objects that a PBL can Hold ?
> 2, Maximum size of a PBL ?
> 3, Which combination of above give me maximum perfomance ?
> 4, Where can I find useful information regarding this ?
> I will be very much thankful for the one who can provide me
> complete INFORMATION ? I would like to get above information
> from a trusty place; so that I can implement with out any
> breach... :-)


Patrice Domange Posted on 2010-04-07 13:26:56.0Z
Sender: 487f.4bbc70d5.1804289383@sybase.com
From: Patrice Domange
Newsgroups: sybase.public.powerbuilder.french.general
Subject: Re: PBL size + Max object
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bbc8820.4c9b.1681692777@sybase.com>
References: <484e1d20.2c74.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Apr 2010 06:26:56 -0700
X-Trace: forums-1-dub 1270646816 10.22.241.41 (7 Apr 2010 06:26:56 -0700)
X-Original-Trace: 7 Apr 2010 06:26:56 -0700, 10.22.241.41
Lines: 58
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.french.general:77
Article PK: 424978

Although, there is no more physical limitation to PBL size,
some says that each PBL Should not exceed 800kb.

From my own experience, good performance are more related to
good sense than PBL size.

Of course, the loading time of the PBL in memory is
proportional to its size, but good performance are more
related on how are distributed needed objets amongs PBLS and
in wich order their are defined in the library path of the
application.

For me, we should splits applications by functional modules,
one pbls for each module. Ancestors, should be loaded first,
then the most used modules at application levels. Each
module's PBL should contains all the descendants objects
needed.
Checks also cross references between objets in a module,
sometime its better to fusion two pbls in one, if most of
the objet of PBL A, needs references of most objects of PBL
B. The only exception for this if for ancestors objets, that
should remain in their framework's original PBls.

Doing that way, PB will load all objects needed according to
the modules effectivelly used, and gain performance as
needed objects will not be splitted in too much pbls, not
getting alongs unneeded objets as much as possible.
Another good tip, is to force PB to load into memory at
least the first must used module Pbl's, for example while
login to the application, by invoking one of its objects. As
PB will had load the definitions of all the objects stored
in this PBL at login time, the instanciations of thoses
objects will be done much faster when the user will invoke
effectivelly the corresponding module. Of course, this will
make the login time a litle bit longer, but who cares if it
will not take more than 1 minutes on the new powerfull PCs ?

In summary, my advices are :
- do not touch to frameworks design
- Split applications in functionals modules, one pbl by
module containing all needed descendant objects.
- Include key End-users in the tests phases to see how their
use the application in order to check the actual functionnal
splitting corresponds to the real usage. If necessary,
splitt or fusions needed Modules(pbls)
- at the end, use the tip explained above to preload the
most used module at application logon, before deploying the
application.

> Hi
> I would like to know the following
> 1, Maximum number of objects that a PBL can Hold ?
> 2, Maximum size of a PBL ?
> 3, Which combination of above give me maximum perfomance ?
> 4, Where can I find useful information regarding this ?
> I will be very much thankful for the one who can provide
> me complete INFORMATION ? I would like to get above
> information from a trusty place; so that I can implement
> with out any breach... :-)