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.

PowerDynamo ODBC Problems

4 posts in General Discussion (old) Last posting was on 2000-03-19 07:59:59.0Z
Darrell Fuller Posted on 2000-03-17 13:58:08.0Z
Newsgroups: sybase.public.easerver
From: "Darrell Fuller" <dfuller@partnerware.com>
Subject: PowerDynamo ODBC Problems
Date: Fri, 17 Mar 2000 07:58:08 -0600
Lines: 21
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
NNTP-Posting-Host: smtp.partnerware.com 38.197.109.2
Message-ID: <347_OxpqVmBk$GA.34@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26217
Article PK: 156887

We've been noticing strange behavior with PD and ODBC. We are using SQL
Anywhere 5.504 and 6.0s as well as Oracle 8i with Merant ODBC 3.5.
Regardless of which database we use, Queries that return large recordsets
over 30,000 ) records are extremely slow.

For example, we can run the SQL directly in ISQL or SQL Worksheet (Native
Connection) and the SQL starts to return rows in a matter of seconds. The
Exact same SQL statement issued from a Dynamo Template takes 7 minutes to
execute connection.CreateQuery().

We have also noticed similiar behavior using JDBC (JConnect). I having
difficulting understanding where the problem exists. The Queries are
complex and there are over 30,000, but that shouldn't account for the
difference in time between using Dynamo and say MS Access over ODBC.

Any help would be appreciated..

Darrell Fuller
dfuller@partnerware.com


Julian Bowker Posted on 2000-03-19 07:59:59.0Z
Newsgroups: sybase.public.easerver
From: "Julian Bowker" <marblesteps@btinternet.com>
Subject: Re: PowerDynamo ODBC Problems
Date: Sun, 19 Mar 2000 07:59:59 -0000
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: host213-1-147-81.btinternet.com 213.1.147.81
Message-ID: <347_XishotXk$GA.201@forums.sybase.com>
References: <347_OxpqVmBk$GA.34@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26114
Article PK: 156116

The reason that ISQL is quicker is that it only retrieves the first page of
results not the complete set. If you page down through the record set you
will notice the time taken to retrieve more records.

Julian Bowker
Marble Steps Systems

"Darrell Fuller" <dfuller@partnerware.com> wrote in message
news:OxpqVmBk$GA.34@forums.sybase.com...
> We've been noticing strange behavior with PD and ODBC. We are using SQL
> Anywhere 5.504 and 6.0s as well as Oracle 8i with Merant ODBC 3.5.
> Regardless of which database we use, Queries that return large recordsets
> over 30,000 ) records are extremely slow.
>
> For example, we can run the SQL directly in ISQL or SQL Worksheet (Native
> Connection) and the SQL starts to return rows in a matter of seconds. The
> Exact same SQL statement issued from a Dynamo Template takes 7 minutes to
> execute connection.CreateQuery().
>
> We have also noticed similiar behavior using JDBC (JConnect). I having
> difficulting understanding where the problem exists. The Queries are
> complex and there are over 30,000, but that shouldn't account for the
> difference in time between using Dynamo and say MS Access over ODBC.
>
> Any help would be appreciated..
>
> Darrell Fuller
> dfuller@partnerware.com
>
>


bobby Posted on 2000-03-17 15:08:01.0Z
Newsgroups: sybase.public.easerver
From: "bobby" <brosenberger@genam.com>
Subject: Re: PowerDynamo ODBC Problems
Date: Fri, 17 Mar 2000 09:08:01 -0600
Lines: 55
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: general.american.genam.com 208.209.229.251
Message-ID: <347_6glUYOCk$GA.111@forums.sybase.com>
References: <347_OxpqVmBk$GA.34@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26206
Article PK: 156876

Darrell,

We are having the same problems while utilizing a cache using the native
Oracle drivers. Large queries are VERY VERY slow. I've had a case open with
technical support since December and they've been very little help. I badger
them several times a week for a status on the problem, but have been getting
very little response. I've contacted our sales rep. and he is supposed to be
contacting a technical support manager... we'll see. We've been extremely
displeased with how this case has been handled.

Our problem is:
We are trying to allow our 'agents' to look at their commission statements
online. Unfortunately, our most productive agents are unable/unwilling to
look at their statements online due to the amount of time it takes to view
the statement. (many times causing a timeout on their browsers) We could
break the statement up into smaller chunks but they don't want to have to
press buttons to go backwards and forwards while looking at their
statements. I can understand that.

To make matters worse, there is a Notes system here that is displaying the
same info in a fraction of the time. Sheds a bad light on EA Server...
especially for the upper management. It gags me to think they might want to
do all of our web-base/n-tier development with Notes. *shudder*

I'm one of Sybase's biggest supporters here and I'm getting the cold
shoulder from their technical support... doesn't seem right.

Bobby R

Darrell Fuller <dfuller@partnerware.com> wrote in message
news:OxpqVmBk$GA.34@forums.sybase.com...
> We've been noticing strange behavior with PD and ODBC. We are using SQL
> Anywhere 5.504 and 6.0s as well as Oracle 8i with Merant ODBC 3.5.
> Regardless of which database we use, Queries that return large recordsets
> over 30,000 ) records are extremely slow.
>
> For example, we can run the SQL directly in ISQL or SQL Worksheet (Native
> Connection) and the SQL starts to return rows in a matter of seconds. The
> Exact same SQL statement issued from a Dynamo Template takes 7 minutes to
> execute connection.CreateQuery().
>
> We have also noticed similiar behavior using JDBC (JConnect). I having
> difficulting understanding where the problem exists. The Queries are
> complex and there are over 30,000, but that shouldn't account for the
> difference in time between using Dynamo and say MS Access over ODBC.
>
> Any help would be appreciated..
>
> Darrell Fuller
> dfuller@partnerware.com
>
>


Larry Cermak[Team Sybase] Posted on 2000-03-18 05:34:05.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: PowerDynamo ODBC Problems
Date: Fri, 17 Mar 2000 23:34:05 -0600
Lines: 86
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_8VdSwzJk$GA.111@forums.sybase.com>
References: <347_OxpqVmBk$GA.34@forums.sybase.com> <347_6glUYOCk$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26141
Article PK: 156821

Not that this is a good alternative, but I've seen the same problem where a
PD query ran EXTREMELY long. I switched it to a datawindow and it was much
better. I originally wanted it as a PD script because I didn't need the
overhead of the web datawindow. However, the larger HTML works better for
me than the slower query in PD.

Also, have you considered creating a jaguar component and letting that issue
the SQL statement to see if that performance is better?

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"bobby" <brosenberger@genam.com> wrote in message
news:6glUYOCk$GA.111@forums.sybase.com...
> Darrell,
>
> We are having the same problems while utilizing a cache using the native
> Oracle drivers. Large queries are VERY VERY slow. I've had a case open
with
> technical support since December and they've been very little help. I
badger
> them several times a week for a status on the problem, but have been
getting
> very little response. I've contacted our sales rep. and he is supposed to
be
> contacting a technical support manager... we'll see. We've been extremely
> displeased with how this case has been handled.
>
> Our problem is:
> We are trying to allow our 'agents' to look at their commission statements
> online. Unfortunately, our most productive agents are unable/unwilling to
> look at their statements online due to the amount of time it takes to view
> the statement. (many times causing a timeout on their browsers) We could
> break the statement up into smaller chunks but they don't want to have to
> press buttons to go backwards and forwards while looking at their
> statements. I can understand that.
>
> To make matters worse, there is a Notes system here that is displaying the
> same info in a fraction of the time. Sheds a bad light on EA Server...
> especially for the upper management. It gags me to think they might want
to
> do all of our web-base/n-tier development with Notes. *shudder*
>
> I'm one of Sybase's biggest supporters here and I'm getting the cold
> shoulder from their technical support... doesn't seem right.
>
> Bobby R
>
>
> Darrell Fuller <dfuller@partnerware.com> wrote in message
> news:OxpqVmBk$GA.34@forums.sybase.com...
> > We've been noticing strange behavior with PD and ODBC. We are using SQL
> > Anywhere 5.504 and 6.0s as well as Oracle 8i with Merant ODBC 3.5.
> > Regardless of which database we use, Queries that return large
recordsets
> > over 30,000 ) records are extremely slow.
> >
> > For example, we can run the SQL directly in ISQL or SQL Worksheet
(Native
> > Connection) and the SQL starts to return rows in a matter of seconds.
The
> > Exact same SQL statement issued from a Dynamo Template takes 7 minutes
to
> > execute connection.CreateQuery().
> >
> > We have also noticed similiar behavior using JDBC (JConnect). I having
> > difficulting understanding where the problem exists. The Queries are
> > complex and there are over 30,000, but that shouldn't account for the
> > difference in time between using Dynamo and say MS Access over ODBC.
> >
> > Any help would be appreciated..
> >
> > Darrell Fuller
> > dfuller@partnerware.com
> >
> >
>
>