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.

DW.NET bugs addendum

3 posts in DataWindow .NET Last posting was on 2004-10-12 13:38:48.0Z
upscale Posted on 2004-10-05 15:54:01.0Z
From: "upscale" <up@scale.com>
Newsgroups: sybase.public.datawindow.net
Subject: DW.NET bugs addendum
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 12.32.34.2
X-Original-NNTP-Posting-Host: 12.32.34.2
Message-ID: <4162c399$1@forums-1-dub>
Date: 5 Oct 2004 08:54:01 -0700
X-Trace: forums-1-dub 1096991641 12.32.34.2 (5 Oct 2004 08:54:01 -0700)
X-Original-Trace: 5 Oct 2004 08:54:01 -0700, 12.32.34.2
X-Authenticated-User: pbtenbeta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:481
Article PK: 124904

Forgot to mention...

using the ADO.NET connection is extremely slow. For example, I can retrieve
a few thousand rows in less than 1 second using the DW.NET OleDb connection
object. However, switching the connection from OleDb to an ADO.NET
connection (same query, same DB, same datawindow, etc) It takes several
minutes. This is unacceptable.


Jim O'Neil [Sybase] Posted on 2004-10-05 17:28:00.0Z
From: "Jim O'Neil [Sybase]" <joneil_at_sybase_dot_com>
Newsgroups: sybase.public.datawindow.net
Subject: Re: DW.NET bugs addendum
Message-ID: <8am5m0t2vo8bm8qpjqs5ogf0kkjjrtr839@4ax.com>
References: <4162c399$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: joneilw2k.sybase.com
X-Original-Trace: 5 Oct 2004 10:27:57 -0700, joneilw2k.sybase.com
Lines: 18
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Oct 2004 10:27:57 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Oct 2004 10:28:00 -0700
X-Trace: forums-1-dub 1096997280 10.22.108.75 (5 Oct 2004 10:28:00 -0700)
X-Original-Trace: 5 Oct 2004 10:28:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:484
Article PK: 124912

Can you open a case on this one. I haven't heard any negatives
regarding performance, and in fact one of the PowerBuilder beta
testers reported that the ADO.NET driver seemed slightly quicker than
OLE-DB. There are certainly quite a few factors that could be
different in your environment though, so it warrants a look by
technical support.

On 5 Oct 2004 08:54:01 -0700, "upscale" <up@scale.com> wrote:

>Forgot to mention...
>
>using the ADO.NET connection is extremely slow. For example, I can retrieve
>a few thousand rows in less than 1 second using the DW.NET OleDb connection
>object. However, switching the connection from OleDb to an ADO.NET
>connection (same query, same DB, same datawindow, etc) It takes several
>minutes. This is unacceptable.
>


upscale Posted on 2004-10-12 13:38:48.0Z
From: "upscale" <up@scale.com>
Newsgroups: sybase.public.datawindow.net
References: <4162c399$1@forums-1-dub> <8am5m0t2vo8bm8qpjqs5ogf0kkjjrtr839@4ax.com>
Subject: Re: DW.NET bugs addendum
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 12.32.34.2
Message-ID: <416bde64$1@forums-2-dub>
X-Original-Trace: 12 Oct 2004 06:38:44 -0700, 12.32.34.2
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Oct 2004 06:38:45 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Oct 2004 06:38:48 -0700
X-Trace: forums-1-dub 1097588328 10.22.108.75 (12 Oct 2004 06:38:48 -0700)
X-Original-Trace: 12 Oct 2004 06:38:48 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:525
Article PK: 124953

After applying the first EBF, the time was reduced to a couple of seconds.
Still slower than the native driver but livable. I should have added that
the CPU is maxed out during this time, same as before. In any event, since
the change in time required to perform this operation has been greatly
reduced, someone is obviously aware of the proplem and has taken steps to
repair it.

"Jim O'Neil [Sybase]" <joneil_at_sybase_dot_com> wrote in message
news:8am5m0t2vo8bm8qpjqs5ogf0kkjjrtr839@4ax.com...
> Can you open a case on this one. I haven't heard any negatives
> regarding performance, and in fact one of the PowerBuilder beta
> testers reported that the ADO.NET driver seemed slightly quicker than
> OLE-DB. There are certainly quite a few factors that could be
> different in your environment though, so it warrants a look by
> technical support.
>
> On 5 Oct 2004 08:54:01 -0700, "upscale" <up@scale.com> wrote:
>
>>Forgot to mention...
>>
>>using the ADO.NET connection is extremely slow. For example, I can
>>retrieve
>>a few thousand rows in less than 1 second using the DW.NET OleDb
>>connection
>>object. However, switching the connection from OleDb to an ADO.NET
>>connection (same query, same DB, same datawindow, etc) It takes several
>>minutes. This is unacceptable.
>>
>