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.

long delays during query

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-30 22:06:48.0Z
Todd Scheetz Posted on 1997-06-16 14:26:44.0Z
Message-ID: <33A54D24.7DEEEFE@eng.uiowa.edu>
Date: Mon, 16 Jun 1997 09:26:44 -0500
From: Todd Scheetz <tscheetz@eng.uiowa.edu>
X-Mailer: Mozilla 4.0b5C (X11; I; SunOS 5.5.1 sun4u)
MIME-Version: 1.0
Subject: long delays during query
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 39
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:674
Article PK: 252426

Hi,

I've been using jConnect successfully with Java 1.0 for a few months
now, but recently we migrated over to Java 1.1, and an annoying problem
popped up.
During certain queries, I'm getting unreasonably long delays (10-30
seconds or more). This occurs with the appletviewer and the hotjava
browser.

This is the GA version which we purchased in early May. The database
we're connecting to is a SQL Server 11.0.

For what it's worth, I've noticed that this seems to occur with queries
with an "order by" in them. But I have run these queries under isql and
they return immediately. Below I've included a portion of the code
displaying this problem.

NOTE: All of the variables are of the appropriate types, and I'm not
getting any array index overflows.

Any and all help appreciated,
-Todd
tscheetz@eng.uiowa.edu

/*****************BEGIN CODE*************************************/

query = "select gel.name,gel.status,gel.plate from gel,lexp where "
+ "gel.lexp_id = lexp.id and lexp.name = 'experiment2' order by
gel.id";
try
{
results = stmt.execute(query);
if(results)
{
rs = stmt.getResultSet();
while(rs.next())
{
WorksheetName[i] = rs.getString(1);
WorksheetStatus[i] = rs.getString(2);
LayoutName[i] = rs.getString(3);
i++;
}
}
}
catch (SQLException sqle)
{
catchSQLEx(sqle);
}
catch (Exception e)
{
catchEx(e);
}


David Clegg Posted on 1997-07-30 22:06:48.0Z
Message-ID: <33DFBAF8.86C56D0@sybase.com>
Date: Wed, 30 Jul 1997 15:06:48 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Todd Scheetz <tscheetz@eng.uiowa.edu>
Subject: Re: long delays during query
References: <33A54D24.7DEEEFE@eng.uiowa.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 35
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:425
Article PK: 252176

You may want to get the latest EBF version of the driver. There
were a number of places where we were creating large objects
and not destroying them explicitly, and one area where we were
never removing references to objects that were no longer being
used.
I suspect that your intermittent delays are caused while the
Garbage collector thread is looking for un-referenced objects
to reclaim. The newer jConnect driver should help if this is
the case.

dave

Todd Scheetz wrote:
>
> Hi,
>
> I've been using jConnect successfully with Java 1.0 for a few months
> now, but recently we migrated over to Java 1.1, and an annoying problem
> popped up.
> During certain queries, I'm getting unreasonably long delays (10-30
> seconds or more). This occurs with the appletviewer and the hotjava
> browser.
>
> This is the GA version which we purchased in early May. The database
> we're connecting to is a SQL Server 11.0.
>
> For what it's worth, I've noticed that this seems to occur with queries
> with an "order by" in them. But I have run these queries under isql and
> they return immediately. Below I've included a portion of the code
> displaying this problem.
>
> NOTE: All of the variables are of the appropriate types, and I'm not
> getting any array index overflows.
>
> Any and all help appreciated,
> -Todd
> tscheetz@eng.uiowa.edu