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.

PD Performance question...

7 posts in General Discussion (old) Last posting was on 2000-02-29 08:54:37.0Z
Scott W Posted on 2000-02-18 02:08:53.0Z
Newsgroups: sybase.public.easerver
From: "Scott W" <no@spam.com>
Subject: PD Performance question...
Date: Thu, 17 Feb 2000 18:08:53 -0800
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: bc17129.bendcable.com 216.228.171.29
Message-ID: <347_Q4kXjVbe$GA.204@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28427
Article PK: 160451

If cache size is not an issue, is there any reason why I wouldn't want to
import a script into all of my templates even though the functions in the
script only get used about half the time.

Specifically, I have a script that houses all of my functions that I use to
validate user entries before allowing the content to be loaded into the DB.
These functions are not always needed, but logistically, it's a pain in the
ass to only load the script when it's needed. Can I simply import it
everytime without sacrificing performance since the script is already in the
cache??

Thanks,

Scott


Dave Wolf [Sybase] Posted on 2000-02-18 02:19:19.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: PD Performance question...
Date: Thu, 17 Feb 2000 21:19:19 -0500
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 158.159.8.32
Message-ID: <347_E7Updgbe$GA.204@forums.sybase.com>
References: <347_Q4kXjVbe$GA.204@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28423
Article PK: 160444

As I understand this will have a negetive performance impact.

1) As you increase cache size the cache can become ineffecient as we have a
larger cache to search. Eventually it becomes slower to search the cache
then hit the database.

2) DynsScript is still interpreted. The longer the script the longer to
interpret. Imagine importing like concatenating the two scripts together.

Dave Wolf
Internet Applications Division

Scott W <no@spam.com> wrote in message
news:Q4kXjVbe$GA.204@forums.sybase.com...
> If cache size is not an issue, is there any reason why I wouldn't want to
> import a script into all of my templates even though the functions in the
> script only get used about half the time.
>
> Specifically, I have a script that houses all of my functions that I use
to
> validate user entries before allowing the content to be loaded into the
DB.
> These functions are not always needed, but logistically, it's a pain in
the
> ass to only load the script when it's needed. Can I simply import it
> everytime without sacrificing performance since the script is already in
the
> cache??
>
> Thanks,
>
> Scott
>
>


Lance Andersen Posted on 2000-02-18 13:32:59.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 18 Feb 2000 08:32:59 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.7 [en] (X11; I; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: PD Performance question...
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 54
NNTP-Posting-Host: alder.sybase.com 157.133.125.15
Message-ID: <347_38AD4A0B.9A5D761C@sybase.com>
References: <347_Q4kXjVbe$GA.204@forums.sybase.com> <347_E7Updgbe$GA.204@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28402
Article PK: 160423


"Dave Wolf [Sybase]" wrote:
>
> As I understand this will have a negetive performance impact.
>
> 1) As you increase cache size the cache can become ineffecient as we have a
> larger cache to search. Eventually it becomes slower to search the cache
> then hit the database.

We used a PD cache size of 100 mb for the Sybase Open and I had
several scripts which imported common code and I did not see
a performance hit using a cache of 50 mb vs 100 mb.

The *real* key is to try and cache as much of your output as possible
so that Dynamo does not have to generate this on a regular basis. I
spent a great deal of time fine-tuning this for the SybaseOpen and
our response times were quite impressive.

Regards,
Lance
>
> 2) DynsScript is still interpreted. The longer the script the longer to
> interpret. Imagine importing like concatenating the two scripts together.
>
> Dave Wolf
> Internet Applications Division
>
> Scott W <no@spam.com> wrote in message
> news:Q4kXjVbe$GA.204@forums.sybase.com...
> > If cache size is not an issue, is there any reason why I wouldn't want to
> > import a script into all of my templates even though the functions in the
> > script only get used about half the time.
> >
> > Specifically, I have a script that houses all of my functions that I use
> to
> > validate user entries before allowing the content to be loaded into the
> DB.
> > These functions are not always needed, but logistically, it's a pain in
> the
> > ass to only load the script when it's needed. Can I simply import it
> > everytime without sacrificing performance since the script is already in
> the
> > cache??
> >
> > Thanks,
> >
> > Scott
> >
> >

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Scott W Posted on 2000-02-28 09:20:42.0Z
Newsgroups: sybase.public.easerver
From: "Scott W" <no@spam.com>
Subject: Re: PD Performance question...
Date: Mon, 28 Feb 2000 01:20:42 -0800
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: bc17129.bendcable.com 216.228.171.29
Message-ID: <347_STuDr1cg$GA.297@forums.sybase.com>
References: <347_Q4kXjVbe$GA.204@forums.sybase.com> <347_E7Updgbe$GA.204@forums.sybase.com> <347_38AD4A0B.9A5D761C@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27685
Article PK: 159049

Lance,

So, if my cache size is well below 50mb, can I feel safe in importing
several scripts with a page? The total lines of code is somewhere around
3000 to 4000 lines combined. I realize that's probably not the best way to
measure, but I'm trying to establish if my resource requirements are
impacting performance, or if they are so far below the capabilities of PD
that I can be liberal when importing...

My cache is currently only 16mb on a 150mb DB.

Thanks,

Scott

>
> We used a PD cache size of 100 mb for the Sybase Open and I had
> several scripts which imported common code and I did not see
> a performance hit using a cache of 50 mb vs 100 mb.
>
> The *real* key is to try and cache as much of your output as possible
> so that Dynamo does not have to generate this on a regular basis. I
> spent a great deal of time fine-tuning this for the SybaseOpen and
> our response times were quite impressive.
>
> Regards,
> Lance
>

============================================================================
===
> Lance J. Andersen Email: lancea@sybase.com
> Sybase Product Support Engineering Phone:(781) 564-6336
> 77 South Bedford Street Fax: (781) 564-7001
> Burlington, MA 01803
>
> The Dark Knight Returns!!! Let's Go Penguins!!!
>
============================================================================
===


Dean Jones [Team Sybase] Posted on 2000-02-29 03:36:24.0Z
Newsgroups: sybase.public.easerver
From: "Dean Jones [Team Sybase]" <dean_no_spam_@powerobjects.com>
Subject: Re: PD Performance question...
Date: Mon, 28 Feb 2000 21:36:24 -0600
Lines: 64
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: dsl131.outtech.com 216.207.145.131
Message-ID: <347_ICHEvbmg$GA.297@forums.sybase.com>
References: <347_Q4kXjVbe$GA.204@forums.sybase.com> <347_E7Updgbe$GA.204@forums.sybase.com> <347_38AD4A0B.9A5D761C@sybase.com> <347_STuDr1cg$GA.297@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27584
Article PK: 158960

Sounds like your getting a lot of script. You might want to begin looking at
writing components that are running in Jaguar and have your PD script call
the components. This will help in two ways. 1. You will move processing off
the web server. 2. you will be running compiled code, using object pooling
and connection cache.

HTH

--

Dean Jones, CPD Professional
Team Sybase
PowerTeam, Inc.
http://www.powerobjects.com

Scott W <no@spam.com> wrote in message
news:STuDr1cg$GA.297@forums.sybase.com...
> Lance,
>
> So, if my cache size is well below 50mb, can I feel safe in importing
> several scripts with a page? The total lines of code is somewhere around
> 3000 to 4000 lines combined. I realize that's probably not the best way
to
> measure, but I'm trying to establish if my resource requirements are
> impacting performance, or if they are so far below the capabilities of PD
> that I can be liberal when importing...
>
> My cache is currently only 16mb on a 150mb DB.
>
> Thanks,
>
> Scott
>
> >
> > We used a PD cache size of 100 mb for the Sybase Open and I had
> > several scripts which imported common code and I did not see
> > a performance hit using a cache of 50 mb vs 100 mb.
> >
> > The *real* key is to try and cache as much of your output as possible
> > so that Dynamo does not have to generate this on a regular basis. I
> > spent a great deal of time fine-tuning this for the SybaseOpen and
> > our response times were quite impressive.
> >
> > Regards,
> > Lance
> >
>
============================================================================
> ===
> > Lance J. Andersen Email: lancea@sybase.com
> > Sybase Product Support Engineering Phone:(781) 564-6336
> > 77 South Bedford Street Fax: (781) 564-7001
> > Burlington, MA 01803
> >
> > The Dark Knight Returns!!! Let's Go Penguins!!!
> >
>
============================================================================
> ===
>
>


Scott W Posted on 2000-02-29 08:54:37.0Z
Newsgroups: sybase.public.easerver
From: "Scott W" <no@spam.com>
Subject: Re: PD Performance question...
Date: Tue, 29 Feb 2000 00:54:37 -0800
Lines: 82
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: bc17129.bendcable.com 216.228.171.29
Message-ID: <347_kQKIwLpg$GA.295@forums.sybase.com>
References: <347_Q4kXjVbe$GA.204@forums.sybase.com> <347_E7Updgbe$GA.204@forums.sybase.com> <347_38AD4A0B.9A5D761C@sybase.com> <347_STuDr1cg$GA.297@forums.sybase.com> <347_ICHEvbmg$GA.297@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27557
Article PK: 158937

Thanks Dean,

Moving to Jaguar and components is ultimately my goal. The problem is I
can't fit in the learning curve right now... Thanks for the advice though.
I'll eventually get on the ball with the rest of you "real" programmers :)

Scott

Dean Jones [Team Sybase] <dean_no_spam_@powerobjects.com> wrote in message
news:ICHEvbmg$GA.297@forums.sybase.com...
> Sounds like your getting a lot of script. You might want to begin looking
at
> writing components that are running in Jaguar and have your PD script call
> the components. This will help in two ways. 1. You will move processing
off
> the web server. 2. you will be running compiled code, using object pooling
> and connection cache.
>
> HTH
>
> --
>
> Dean Jones, CPD Professional
> Team Sybase
> PowerTeam, Inc.
> http://www.powerobjects.com
>
>
> Scott W <no@spam.com> wrote in message
> news:STuDr1cg$GA.297@forums.sybase.com...
> > Lance,
> >
> > So, if my cache size is well below 50mb, can I feel safe in importing
> > several scripts with a page? The total lines of code is somewhere
around
> > 3000 to 4000 lines combined. I realize that's probably not the best way
> to
> > measure, but I'm trying to establish if my resource requirements are
> > impacting performance, or if they are so far below the capabilities of
PD
> > that I can be liberal when importing...
> >
> > My cache is currently only 16mb on a 150mb DB.
> >
> > Thanks,
> >
> > Scott
> >
> > >
> > > We used a PD cache size of 100 mb for the Sybase Open and I had
> > > several scripts which imported common code and I did not see
> > > a performance hit using a cache of 50 mb vs 100 mb.
> > >
> > > The *real* key is to try and cache as much of your output as possible
> > > so that Dynamo does not have to generate this on a regular basis. I
> > > spent a great deal of time fine-tuning this for the SybaseOpen and
> > > our response times were quite impressive.
> > >
> > > Regards,
> > > Lance
> > >
> >
>
============================================================================
> > ===
> > > Lance J. Andersen Email: lancea@sybase.com
> > > Sybase Product Support Engineering Phone:(781) 564-6336
> > > 77 South Bedford Street Fax: (781) 564-7001
> > > Burlington, MA 01803
> > >
> > > The Dark Knight Returns!!! Let's Go Penguins!!!
> > >
> >
>
============================================================================
> > ===
> >
> >
>
>


Scott W Posted on 2000-02-18 08:08:02.0Z
Newsgroups: sybase.public.easerver
From: "Scott W" <no@spam.com>
Subject: Re: PD Performance question...
Date: Fri, 18 Feb 2000 00:08:02 -0800
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: bc17129.bendcable.com 216.228.171.29
Message-ID: <347_A#BOPeee$GA.184@forums.sybase.com>
References: <347_Q4kXjVbe$GA.204@forums.sybase.com> <347_E7Updgbe$GA.204@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28412
Article PK: 160434

Thanks for the help Dave... At least I now know that I can't take the easy
way out. Oh well...

Scott

Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
news:E7Updgbe$GA.204@forums.sybase.com...
> As I understand this will have a negetive performance impact.
>
> 1) As you increase cache size the cache can become ineffecient as we have
a
> larger cache to search. Eventually it becomes slower to search the cache
> then hit the database.
>
> 2) DynsScript is still interpreted. The longer the script the longer to
> interpret. Imagine importing like concatenating the two scripts together.
>
> Dave Wolf
> Internet Applications Division
>
>
> Scott W <no@spam.com> wrote in message
> news:Q4kXjVbe$GA.204@forums.sybase.com...
> > If cache size is not an issue, is there any reason why I wouldn't want
to
> > import a script into all of my templates even though the functions in
the
> > script only get used about half the time.
> >
> > Specifically, I have a script that houses all of my functions that I use
> to
> > validate user entries before allowing the content to be loaded into the
> DB.
> > These functions are not always needed, but logistically, it's a pain in
> the
> > ass to only load the script when it's needed. Can I simply import it
> > everytime without sacrificing performance since the script is already in
> the
> > cache??
> >
> > Thanks,
> >
> > Scott
> >
> >
>
>