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.

.NET iAnywhere native driver

3 posts in General Discussion Last posting was on 2009-11-04 14:41:18.0Z
a.sahan Posted on 2009-08-27 19:35:04.0Z
Sender: 3b2d.4a96de8d.1804289383@sybase.com
From: a.sahan
Newsgroups: ianywhere.public.general
Subject: .NET iAnywhere native driver
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a96dfe8.3b71.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Aug 2009 12:35:04 -0700
X-Trace: forums-1-dub 1251401704 10.22.241.41 (27 Aug 2009 12:35:04 -0700)
X-Original-Trace: 27 Aug 2009 12:35:04 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7699
Article PK: 6741

Hi,

I am trying to use iAnywhere.Data.Asaclient from my C#
(.NETFX 3.5) program to access SQL Anywhere 9.0.2 db. The
problem is about the performance. I was thinking that Native
driver access would be better than ODBC type access.
However, it is not. I implemented db access through
DbProviderFactory class interface and during connection
phase, it waits too much time while generating
DbFactory/DbConnection objects. What could be the reason of
this performance issue? How can I solve it?
Thanks.


David Fishburn [Sybase iAnywhere] Posted on 2009-10-13 19:52:43.0Z
Newsgroups: ianywhere.public.general
Subject: Re: .NET iAnywhere native driver
From: "David Fishburn [Sybase iAnywhere]" <fishburn_spam_off@ianywhere.com>
References: <4a96dfe8.3b71.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns9CA3A18703415fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/2005.10.18
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 13 Oct 2009 12:52:43 -0700
X-Trace: forums-1-dub 1255463563 10.22.241.152 (13 Oct 2009 12:52:43 -0700)
X-Original-Trace: 13 Oct 2009 12:52:43 -0700, vip152.sybase.com
Lines: 49
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7757
Article PK: 6793

a.sahan wrote in news:4a96dfe8.3b71.1681692777@sybase.com
of ianywhere.public.general:

as> I am trying to use iAnywhere.Data.Asaclient from my C#
as> (.NETFX 3.5) program to access SQL Anywhere 9.0.2 db. The
as> problem is about the performance. I was thinking that Native
as> driver access would be better than ODBC type access.
as> However, it is not. I implemented db access through
as> DbProviderFactory class interface and during connection
as> phase, it waits too much time while generating
as> DbFactory/DbConnection objects. What could be the reason of
as> this performance issue? How can I solve it?

This sounds like a problem with the DbFactory objects.

When these objects connect to the database what requests do they send
to the database server?

You can figure this out by turning on request logging (see the Help
file). Note, request logging slows the server down (significantly)
but it does allow you to see the requests the clients are asking the
server to run.

So turn it on, run your client, turn it off, then look at the output
provided.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng11 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/

Developer Community / Whitepapers
http://www.ianywhere.com/developer

Case-Express - to report bugs
http://case-express.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList

Documentation
http://dcx.sybase.com/


a.sahan Posted on 2009-11-04 14:41:18.0Z
Sender: 448d.4af18ccd.1804289383@sybase.com
From: a.sahan
Newsgroups: ianywhere.public.general
Subject: Re: .NET iAnywhere native driver
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4af1928e.456d.1681692777@sybase.com>
References: <Xns9CA3A18703415fishburnsybasecom@10.22.241.106>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 Nov 2009 06:41:18 -0800
X-Trace: forums-1-dub 1257345678 10.22.241.41 (4 Nov 2009 06:41:18 -0800)
X-Original-Trace: 4 Nov 2009 06:41:18 -0800, 10.22.241.41
Lines: 66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7795
Article PK: 6831

Thank you for your answer.

as I understand from your reply, the slowing down should
happen at connection phase. However, the problem is before
connection attempt.
DbProviderFactories.GetFactory("ianywhere.AsaClient") method
locks for a while (10 to 20 sec.) and then returns the
DbProvider object. Therefore I am not sure that request
logging would be helpful. Why does it take so long to get
Dbprovider?I can not find the reason.

> a.sahan wrote in news:4a96dfe8.3b71.1681692777@sybase.com
> of ianywhere.public.general:
>
> as> I am trying to use iAnywhere.Data.Asaclient from my C#
> as> (.NETFX 3.5) program to access SQL Anywhere 9.0.2 db.
> The as> problem is about the performance. I was thinking
> that Native as> driver access would be better than ODBC
> type access. as> However, it is not. I implemented db
> access through as> DbProviderFactory class interface and
> during connection as> phase, it waits too much time while
> generating as> DbFactory/DbConnection objects. What could
> be the reason of as> this performance issue? How can I
> solve it?
>
> This sounds like a problem with the DbFactory objects.
>
> When these objects connect to the database what requests
> do they send to the database server?
>
> You can figure this out by turning on request logging (see
> the Help file). Note, request logging slows the server
> down (significantly) but it does allow you to see the
> requests the clients are asking the server to run.
>
> So turn it on, run your client, turn it off, then look at
> the output provided.
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD
> number with EACH post (dbeng11 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> Case-Express - to report bugs
> http://case-express.sybase.com
>
> CodeXchange - Free samples
>
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList
>
> Documentation
> http://dcx.sybase.com/
>