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 11 JDBC driver slower than jconn?

21 posts in General Discussion Last posting was on 2010-02-25 16:31:08.0Z
Brian Howard Posted on 2010-02-22 17:36:08.0Z
Sender: 213c.4b82a8ad.1804289383@sybase.com
From: Brian Howard
Newsgroups: ianywhere.public.general
Subject: ASA 11 JDBC driver slower than jconn?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b82c088.25a4.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Feb 2010 09:36:08 -0800
X-Trace: forums-1-dub 1266860168 10.22.241.41 (22 Feb 2010 09:36:08 -0800)
X-Original-Trace: 22 Feb 2010 09:36:08 -0800, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7914
Article PK: 6946

I'm having a strage case here where our application actually
runs slower with the new ASA 11 JDBC ODBC driver! In V9 ASA,
the ASA JDBC/ODBC driver ran circles around the jconnect
products.

Anyone seeing similar issues? (I'm hoping I just have a a
configuration issue here).

I just tried against a V9 database and a V11 database
engine. Same results.

thanks!

brian


Karim Khamis [Sybase iAnywhere] Posted on 2010-02-22 18:24:18.0Z
From: "Karim Khamis [Sybase iAnywhere]" <kkhamis@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA 11 JDBC driver slower than jconn?
References: <4b82c088.25a4.1681692777@sybase.com>
In-Reply-To: <4b82c088.25a4.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b82cbd2$1@forums-1-dub>
Date: 22 Feb 2010 10:24:18 -0800
X-Trace: forums-1-dub 1266863058 10.22.241.152 (22 Feb 2010 10:24:18 -0800)
X-Original-Trace: 22 Feb 2010 10:24:18 -0800, vip152.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7916
Article PK: 6943

Brian,

Check the URL that you are using. If the URL begins with jdbc:odbc:,
then I would strongly suggest changing the URL header to jdbc:ianywhere:
instead and see if that resolves the problem. My guess is that if you
are using jdbc:odbc as your URL header, then you are getting the Sun
JDBC-ODBC bridge instead of the iAnywhere JDBC driver.

Karim

Brian Howard wrote:
> I'm having a strage case here where our application actually
> runs slower with the new ASA 11 JDBC ODBC driver! In V9 ASA,
> the ASA JDBC/ODBC driver ran circles around the jconnect
> products.
>
> Anyone seeing similar issues? (I'm hoping I just have a a
> configuration issue here).
>
> I just tried against a V9 database and a V11 database
> engine. Same results.
>
> thanks!
>
> brian


Brian Howard Posted on 2010-02-22 18:43:44.0Z
Sender: 213c.4b82a8ad.1804289383@sybase.com
From: Brian Howard
Newsgroups: ianywhere.public.general
Subject: Re: ASA 11 JDBC driver slower than jconn?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b82d05f.27a0.1681692777@sybase.com>
References: <4b82cbd2$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Feb 2010 10:43:44 -0800
X-Trace: forums-1-dub 1266864224 10.22.241.41 (22 Feb 2010 10:43:44 -0800)
X-Original-Trace: 22 Feb 2010 10:43:44 -0800, 10.22.241.41
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7917
Article PK: 6945

Karim,

Thanks for the response. I checked that one first (that
issue got us a while back on another issue).

I'm trying to reduce the problem now - before opening an
official case on this one. As usual, a "real world" app has
a lot going on and it isn't super easy. I'm hoping something
else like the URL is all we are doing wrong - not sure if
others have seen this one or not.

> Brian,
>
> Check the URL that you are using. If the URL begins with
> jdbc:odbc:, then I would strongly suggest changing the
> URL header to jdbc:ianywhere: instead and see if that
> resolves the problem. My guess is that if you are using
> jdbc:odbc as your URL header, then you are getting the Sun
> JDBC-ODBC bridge instead of the iAnywhere JDBC driver.
>
> Karim
> Brian Howard wrote:
> > I'm having a strage case here where our application
> > actually runs slower with the new ASA 11 JDBC ODBC
> > driver! In V9 ASA, the ASA JDBC/ODBC driver ran circles
> > around the jconnect products.
> >
> > Anyone seeing similar issues? (I'm hoping I just have a
> > a configuration issue here).
> >
> > I just tried against a V9 database and a V11 database
> > engine. Same results.
> >
> > thanks!
> >
> > brian


Karim Khamis [Sybase iAnywhere] Posted on 2010-02-22 19:12:52.0Z
From: "Karim Khamis [Sybase iAnywhere]" <kkhamis@sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA 11 JDBC driver slower than jconn?
References: <4b82cbd2$1@forums-1-dub> <4b82d05f.27a0.1681692777@sybase.com>
In-Reply-To: <4b82d05f.27a0.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b82d734$1@forums-1-dub>
Date: 22 Feb 2010 11:12:52 -0800
X-Trace: forums-1-dub 1266865972 10.22.241.152 (22 Feb 2010 11:12:52 -0800)
X-Original-Trace: 22 Feb 2010 11:12:52 -0800, vip152.sybase.com
Lines: 53
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7918
Article PK: 6949

Brian,

When you say you tried against a V9 and a V11 database, does that mean
that you tried the app with the SA 11 JDBC driver against an ASA 9
server and then ran the app against the SA 11 server? Did you use the
same ODBC driver in both cases or did you use the 11 ODBC driver against
the 11 server and the 9 ODBC driver against the 9 server? If you did
switch ODBC drivers, then you might want to consider using the 9 ODBC
driver against both the 11 and 9 servers but keep the 11 JDBC driver in
place. That will at least eliminate the ODBC driver from the equation.
Also, try running the 9 JDBC driver with both the 9 and 11 ODBC drivers
against the 11 server and see if your application performance increases.

Karim

Brian Howard wrote:
> Karim,
>
> Thanks for the response. I checked that one first (that
> issue got us a while back on another issue).
>
> I'm trying to reduce the problem now - before opening an
> official case on this one. As usual, a "real world" app has
> a lot going on and it isn't super easy. I'm hoping something
> else like the URL is all we are doing wrong - not sure if
> others have seen this one or not.
>
>
>
>> Brian,
>>
>> Check the URL that you are using. If the URL begins with
>> jdbc:odbc:, then I would strongly suggest changing the
>> URL header to jdbc:ianywhere: instead and see if that
>> resolves the problem. My guess is that if you are using
>> jdbc:odbc as your URL header, then you are getting the Sun
>> JDBC-ODBC bridge instead of the iAnywhere JDBC driver.
>>
>> Karim
>> Brian Howard wrote:
>>> I'm having a strage case here where our application
>>> actually runs slower with the new ASA 11 JDBC ODBC
>>> driver! In V9 ASA, the ASA JDBC/ODBC driver ran circles
>>> around the jconnect products.
>>>
>>> Anyone seeing similar issues? (I'm hoping I just have a
>>> a configuration issue here).
>>>
>>> I just tried against a V9 database and a V11 database
>>> engine. Same results.
>>>
>>> thanks!
>>>
>>> brian


Jeff Albion [Sybase iAnywhere] Posted on 2010-02-23 17:35:20.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA 11 JDBC driver slower than jconn?
References: <4b82d734$1@forums-1-dub> <4b82ee7f.2c2b.1681692777@sybase.com>
In-Reply-To: <4b82ee7f.2c2b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b8411d8$1@forums-1-dub>
Date: 23 Feb 2010 09:35:20 -0800
X-Trace: forums-1-dub 1266946520 10.22.241.152 (23 Feb 2010 09:35:20 -0800)
X-Original-Trace: 23 Feb 2010 09:35:20 -0800, vip152.sybase.com
Lines: 54
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7930
Article PK: 6958

Hi Brian,

On 2/22/2010 3:52 PM, Brian Howard wrote:
> reported in the ODBC setup for ASAODBC: 11.00.00.1490

First, I'd recommend trying the 11.0.1 maintenance patch and the
11.0.1.2376 EBF to see if the server performance changes. There were a
number of isolated performance issues resolved shortly after 11.0.1 GA.

See:
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
for downloads.

> query(conn, "SELECT * FROM CHSC_USERS");
> query(conn, "SELECT * FROM CHSC_PO po, CHSC_PO_PROBLEM prob WHERE po.DBID = prob.DBID AND po.POID = prob.POID AND prob.Resolved<> 'Y' AND (po.\"CSRUSERID\" = 'DEMO' OR prob.\"CREATEUSERID\" = 'DEMO') AND (( po .CREATETERRITORYID IN ('TRTY'))OR( ( select count(*) from CHSC_POSplit split, CHSC_Users uu WHERE po .DBID = split.DBID AND po .POID = split.POID AND split.AccountID = uu.AccountID AND uu.UserID = 'DEMO')> 0 )) ORDER BY po.\"ENTRYDATE\" desc, po.\"PONUMBER\""

Out of curiosity, have you tried running these two queries outside of
JDBC entirely, just to see what the server performance is like between
9.0.2 and 11.0.1?

You can test this performance in ESQL using a utility called "fetchtst"
included with the product samples. Create this SQL file:

======
SELECT * FROM CHSC_USERS
go

SELECT * FROM CHSC_PO po, CHSC_PO_PROBLEM prob WHERE po.DBID =
prob.DBID AND po.POID = prob.POID AND prob.Resolved <> 'Y' AND
(po."CSRUSERID" = 'DEMO' OR prob."CREATEUSERID" = 'DEMO') AND ((
po.CREATETERRITORYID IN ('TRTY'))OR( ( select count(*) from
CHSC_POSplit split, CHSC_Users uu WHERE po .DBID = split.DBID AND
po.POID = split.POID AND split.AccountID = uu.AccountID AND uu.UserID
= 'DEMO')> 0 )) ORDER BY po."ENTRYDATE" desc, po.\"PONUMBER\"
go
======

and run this file through the fetchtst utility (see:
http://dcx.sybase.com/index.php#1101en/dbusage_en11/performance-s-5787658.html
and
"SQLANY11%\Samples\SQLAnywhere\PerformanceFetch\fetchtst.exe" ) for both
9.0.2 and 11.0.1.

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


"Kory Hodgson (Sybase iAnywhere)" <khodgson Posted on 2010-02-22 18:11:12.0Z
From: "Kory Hodgson (Sybase iAnywhere)" <khodgson@A_SPAM_FREE_sybase.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA 11 JDBC driver slower than jconn?
References: <4b82c088.25a4.1681692777@sybase.com>
In-Reply-To: <4b82c088.25a4.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b82c8c0@forums-1-dub>
Date: 22 Feb 2010 10:11:12 -0800
X-Trace: forums-1-dub 1266862272 10.22.241.152 (22 Feb 2010 10:11:12 -0800)
X-Original-Trace: 22 Feb 2010 10:11:12 -0800, vip152.sybase.com
Lines: 20
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7915
Article PK: 6944

What version and build of SQL Anywhere 11 and 9 are you comparing?

Do you have examples of queries that are seeing differences in performance?

Brian Howard wrote:
> I'm having a strage case here where our application actually
> runs slower with the new ASA 11 JDBC ODBC driver! In V9 ASA,
> the ASA JDBC/ODBC driver ran circles around the jconnect
> products.
>
> Anyone seeing similar issues? (I'm hoping I just have a a
> configuration issue here).
>
> I just tried against a V9 database and a V11 database
> engine. Same results.
>
> thanks!
>
> brian