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.

tuning on ASE 1254 / 1502 for XQL, installjava

8 posts in Performance and Tuning Last posting was on 2008-03-28 02:00:34.0Z
dbMethods Posted on 2008-03-25 03:06:25.0Z
Message-ID: <47e86c31@forums-1-dub>
From: dbMethods <dbmethods@nospam.com>
Subject: tuning on ASE 1254 / 1502 for XQL, installjava
Newsgroups: sybase.public.ase.performance+tuning
Lines: 3
User-Agent: KNode/0.10.4
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 24 Mar 2008 19:06:25 -0800
X-Trace: forums-1-dub 1206414385 10.22.241.152 (24 Mar 2008 19:06:25 -0800)
X-Original-Trace: 24 Mar 2008 19:06:25 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10730
Article PK: 89344

Any ideas on how to do performance tuning or setup on server side java/XML.

Thanks


Derek Asirvadem Posted on 2008-03-25 12:52:48.0Z
From: Derek Asirvadem <derek@softwaregemsNOSPAMcomDOTau>
Organization: Software Gems Pty Ltd
Newsgroups: sybase.public.ase.performance+tuning
Message-ID: <47e8f59f@forums-1-dub>
References: <47e86c31@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: tuning on ASE 1254 / 1502 for XQL, installjava
User-Agent: Unison/1.7.7
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Mar 2008 04:52:48 -0800
X-Trace: forums-1-dub 1206449568 10.22.241.152 (25 Mar 2008 04:52:48 -0800)
X-Original-Trace: 25 Mar 2008 04:52:48 -0800, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10731
Article PK: 89345


> On 2008-03-25 14:06:25 +1100, dbMethods <dbmethods@nospam.com> said:
>
> Any ideas on how to do performance tuning or setup on server side java/XML.

That's a pretty broad question, can you narrow it down a bit.
Basically, you would do P&T on ASE as usual, very little diff for
Java/XML, and even then, only if you want to enhance that over other
facilities. MOst of the "java" P&T is in the EAServer or middle ware
layer, not really in ASE. The most common bits that java coders miss
is:

• always use sprocs
--
Cheers
Derek
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
Quality Standards = Zero Maintenance + Zero Surprises
Performance Standards = Predictability + Scaleability


dbMethods Posted on 2008-03-25 23:36:27.0Z
Message-ID: <47e98c7b@forums-1-dub>
From: dbMethods <dbmethods@nospam.com>
Subject: Re: tuning on ASE 1254 / 1502 for XQL, installjava
Newsgroups: sybase.public.ase.performance+tuning
References: <47e86c31@forums-1-dub> <47e8f59f@forums-1-dub>
Lines: 22
User-Agent: KNode/0.10.4
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8Bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Mar 2008 15:36:27 -0800
X-Trace: forums-1-dub 1206488187 10.22.241.152 (25 Mar 2008 15:36:27 -0800)
X-Original-Trace: 25 Mar 2008 15:36:27 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10734
Article PK: 89348


Derek Asirvadem wrote:

>> On 2008-03-25 14:06:25 +1100, dbMethods <dbmethods@nospam.com> said:
>>
>> Any ideas on how to do performance tuning or setup on server side
>> java/XML.
>
> That's a pretty broad question, can you narrow it down a bit.
> Basically, you would do P&T on ASE as usual, very little diff for
> Java/XML, and even then, only if you want to enhance that over other
> facilities. MOst of the "java" P&T is in the EAServer or middle ware
> layer, not really in ASE. The most common bits that java coders miss
> is:
>
> • always use sprocs

What I am looking for is ASE server side java or XML inside the ASE portion.
I am not talking about EAserver or IBM Webphere here.

My firm standardized on IBM Webphere, EAserver is losing ground I think.


Derek Asirvadem Posted on 2008-03-26 01:08:40.0Z
From: Derek Asirvadem <derek@softwaregemsNOSPAMcomDOTau>
Organization: Software Gems Pty Ltd
Newsgroups: sybase.public.ase.performance+tuning
Message-ID: <47e9a218@forums-1-dub>
References: <47e86c31@forums-1-dub> <47e8f59f@forums-1-dub> <47e98c7b@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: tuning on ASE 1254 / 1502 for XQL, installjava
User-Agent: Unison/1.7.7
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Mar 2008 17:08:40 -0800
X-Trace: forums-1-dub 1206493720 10.22.241.152 (25 Mar 2008 17:08:40 -0800)
X-Original-Trace: 25 Mar 2008 17:08:40 -0800, vip152.sybase.com
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10735
Article PK: 89351


> On 2008-03-26 10:36:27 +1100, dbMethods <dbmethods@nospam.com> said:
>
> What I am looking for is ASE server side java or XML inside the ASE portion.
> I am not talking about EAserver or IBM Webphere here.

Well, Java and XML inside ASE are two diff things now. XML is fully
integrated without being dependent on Java, since 12.5.3 (from my use
of it, not from declaration). 12.5.4 improved it. 15.0.2 has serious
enhancements for both. Best bet is the other newsgroup and search the
web (not suggesting that the info on the web re anything is "good").

For inside-ASE category, there is no extra or special need for Java/XML
(assuming of course that you have RTFM and configured it accordingly).
As always, the main approach is to understand your data and the load
(how ASE is used by the app/users), and perform ASE resource allocation
and P&T in iterations. There is also the issue of binding the o/s
resources to ASE so that you have a dedicated Db server (or not).
Again, this is normal
(a) h/w configuration and distribution
(b) h/w & o/s dedication
(c) ASE resource allocation and distribution
(d) P&T iterations,
nothing special for Java/XML. If you understand the principles of
architecture, ASE internals, and have done it before, it is easier;
otherwise just throw yourself at it and learn, post questions.

Where it really matters is the physical table design, if you have
loosely defined objects, and lots of varchars then ASE will have to
work more to drag out or insert them (nothing is free), and your tables
will be slower (on the same h/w and rsc alloc). Therefore reduce the
number of such columns/objects by design.
--
Cheers
Derek
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
Quality Standards = Zero Maintenance + Zero Surprises
Performance Standards = Predictability + Scaleability


Derek Asirvadem Posted on 2008-03-26 01:23:56.0Z
From: Derek Asirvadem <derek@softwaregemsNOSPAMcomDOTau>
Organization: Software Gems Pty Ltd
Newsgroups: sybase.public.ase.performance+tuning
Message-ID: <47e9a5ab@forums-1-dub>
References: <47e86c31@forums-1-dub> <47e8f59f@forums-1-dub> <47e98c7b@forums-1-dub> <47e9a218@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: tuning on ASE 1254 / 1502 for XQL, installjava
User-Agent: Unison/1.7.7
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Mar 2008 17:23:56 -0800
X-Trace: forums-1-dub 1206494636 10.22.241.152 (25 Mar 2008 17:23:56 -0800)
X-Original-Trace: 25 Mar 2008 17:23:56 -0800, vip152.sybase.com
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10736
Article PK: 89352

Also ...

Do not be alarmed by stack traces (ASE has to de/compile Java/XML
datatypes which it does in "data" space) which are (in the context of
Java/XML) now most commonly due to coding errors and invalid attempts
to do something, not due to internal errors or incorrect QPs, etc. All
it now means is, the thread failed. Except a stacktrace with signal
11, which is not recoverable but that is not caused by the above.

Also, EAServer is beautifully integrated with ASE, configuring
connection pools, etc. is easy. Couple of years since I did a
WebSphere deployment, but IIRC it is quite fiddly but you can do it.
Point is, you need to identify and exploit the facilities for
ASE-middleware integration, you do not want millions of quick
connects/disconnets, anonymous logins, etc.
--
Cheers
Derek
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
Quality Standards = Zero Maintenance + Zero Surprises
Performance Standards = Predictability + Scaleability


dbMethods Posted on 2008-03-27 22:18:29.0Z
Message-ID: <47ec1d34@forums-1-dub>
From: dbMethods <dbmethods@nospam.com>
Subject: Re: tuning on ASE 1254 / 1502 for XQL, installjava
Newsgroups: sybase.public.ase.performance+tuning
References: <47e86c31@forums-1-dub> <47e8f59f@forums-1-dub> <47e98c7b@forums-1-dub> <47e9a218@forums-1-dub>
Lines: 43
User-Agent: KNode/0.10.4
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 27 Mar 2008 14:18:29 -0800
X-Trace: forums-1-dub 1206656309 10.22.241.152 (27 Mar 2008 14:18:29 -0800)
X-Original-Trace: 27 Mar 2008 14:18:29 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10740
Article PK: 89353

The keywords here configured it accordingly.
How and why, does Sybase have tool set here? Or there is another learning
curve, try and error and conquer and divide?

Does ASE have all pieces here, installxml or installserversidejave, so I can
give it a try?

Thanks

Derek Asirvadem wrote:

>> On 2008-03-26 10:36:27 +1100, dbMethods <dbmethods@nospam.com> said:
>>
>> What I am looking for is ASE server side java or XML inside the ASE
>> portion. I am not talking about EAserver or IBM Webphere here.
>
> Well, Java and XML inside ASE are two diff things now. XML is fully
> integrated without being dependent on Java, since 12.5.3 (from my use
> of it, not from declaration). 12.5.4 improved it. 15.0.2 has serious
> enhancements for both. Best bet is the other newsgroup and search the
> web (not suggesting that the info on the web re anything is "good").
>
> For inside-ASE category, there is no extra or special need for Java/XML
> (assuming of course that you have RTFM and configured it accordingly).
> As always, the main approach is to understand your data and the load
> (how ASE is used by the app/users), and perform ASE resource allocation
> and P&T in iterations. There is also the issue of binding the o/s
> resources to ASE so that you have a dedicated Db server (or not).
> Again, this is normal
> (a) h/w configuration and distribution
> (b) h/w & o/s dedication
> (c) ASE resource allocation and distribution
> (d) P&T iterations,
> nothing special for Java/XML. If you understand the principles of
> architecture, ASE internals, and have done it before, it is easier;
> otherwise just throw yourself at it and learn, post questions.
>
> Where it really matters is the physical table design, if you have
> loosely defined objects, and lots of varchars then ASE will have to
> work more to drag out or insert them (nothing is free), and your tables
> will be slower (on the same h/w and rsc alloc). Therefore reduce the
> number of such columns/objects by design.


Derek Asirvadem Posted on 2008-03-28 02:00:34.0Z
From: Derek Asirvadem <derek.asirvadem@gmailDOTcom>
Organization: Software Gems Pty Ltd
Newsgroups: sybase.public.ase.performance+tuning
Message-ID: <47ec5141@forums-1-dub>
References: <47e86c31@forums-1-dub> <47e8f59f@forums-1-dub> <47e98c7b@forums-1-dub> <47e9a218@forums-1-dub> <47ec1d34@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: tuning on ASE 1254 / 1502 for XQL, installjava
User-Agent: Unison/1.7.7
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 27 Mar 2008 18:00:34 -0800
X-Trace: forums-1-dub 1206669634 10.22.241.152 (27 Mar 2008 18:00:34 -0800)
X-Original-Trace: 27 Mar 2008 18:00:34 -0800, vip152.sybase.com
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10741
Article PK: 89354


> On 2008-03-28 09:18:29 +1100, dbMethods <dbmethods@nospam.com> said:
>
> The keywords here configured it accordingly. How and why, does Sybase
> have tool set here? Does ASE have all pieces here, installxml or
> installserversidejave, so I can give it a try?

Of course. look in your scripts (look for the install*) and sample
directory, the pubs Dbs. Manuals, white papers. Infocenter. Google.

> Or there is another learning curve, try and error and conquer and divide?

Well, of course you will have a learning curve learning and
implementing anything new; make a few mistakes; improve the code; etc.
The steepness of the learning curve depends on what you already know;
how much exp you have; whether you have standards. That's why people
sell, and other people buy, education. There are no magic pills in
Syb/Ora/MS. If you want an enterprise Db/Java server, there will be
many levels to the structures; the more you udnerstand them, the better
your architecture and code will be.
--
Cheers
Derek
Senior Sybase DBA / Information Architect
Copyright © 2008 Software Gems Pty Ltd
Quality Standards = Zero Maintenance + Zero Surprises
Performance Standards = Predictability + Scaleability


Sherlock, Kevin Posted on 2008-03-25 15:13:22.0Z
From: "Sherlock, Kevin" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.performance+tuning
References: <47e86c31@forums-1-dub>
Subject: Re: tuning on ASE 1254 / 1502 for XQL, installjava
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47e91692$1@forums-1-dub>
Date: 25 Mar 2008 07:13:22 -0800
X-Trace: forums-1-dub 1206458002 10.22.241.152 (25 Mar 2008 07:13:22 -0800)
X-Original-Trace: 25 Mar 2008 07:13:22 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:10732
Article PK: 89347

That's a good question. There is a newsgroup for xml
(sybase.public.ase.xml) where there may be better heads to help you. There
has been some traffic there, so you may want to post this over there to see
if anyone has any ideas.

"dbMethods" <dbmethods@nospam.com> wrote in message
news:47e86c31@forums-1-dub...
> Any ideas on how to do performance tuning or setup on server side
> java/XML.
>
> Thanks