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.

JConnect Connection Speed

3 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-30 20:31:44.0Z
H. Jenny Zhan Posted on 1997-06-24 01:21:54.0Z
Message-ID: <33AF2132.1AA8@dnai.com>
Date: Mon, 23 Jun 1997 18:21:54 -0700
From: "H. Jenny Zhan" <hzhan@dnai.com>
Reply-To: hzhan@dnai.com
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: JConnect Connection Speed
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:643
Article PK: 252396

Hi,

We have developed a test application using JConnect and benchmarked the
performance. The query speed sounds fine for us, but the Sybase
connection takes 30-40 seconds, which is unacceptable in our
application. The JDBC version we are using is 1.02. Since our web server
and database server are on different machine, applets connect to
database trhough Casecade HTTP Gateway. Our company Intranet is on T1
line. May I know how we could speed up the connection? It will affect
our purchase decision.


Jenny


David Clegg Posted on 1997-07-30 20:31:44.0Z
Message-ID: <33DFA4B0.70A3CA3@sybase.com>
Date: Wed, 30 Jul 1997 13:31:44 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: hzhan@dnai.com
Subject: Re: JConnect Connection Speed
References: <33AF2132.1AA8@dnai.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 27
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:441
Article PK: 252192

I have never seen connections take that long, either direct to the
database or through the gateway. Are you sure you are not including
the time to download the bytecodes for your applet?
I'm almost certain that if you use a timer inside your applet that
you start and stop around the getConnection() call that it will be
much faster (the 2nd time you connect).

If it really is taking 30-40 seconds just to connect there is something
wrong with your browser.

dave

H. Jenny Zhan wrote:
>
> Hi,
>
> We have developed a test application using JConnect and benchmarked the
> performance. The query speed sounds fine for us, but the Sybase
> connection takes 30-40 seconds, which is unacceptable in our
> application. The JDBC version we are using is 1.02. Since our web server
> and database server are on different machine, applets connect to
> database trhough Casecade HTTP Gateway. Our company Intranet is on T1
> line. May I know how we could speed up the connection? It will affect
> our purchase decision.
>
> Jenny


Mary Peek Posted on 1997-06-25 01:15:15.0Z
Message-ID: <33B07123.6544@sybase.com>
Date: Tue, 24 Jun 1997 18:15:15 -0700
From: Mary Peek <maryp@sybase.com>
Reply-To: maryp@sybase.com
Organization: Sybase
X-Mailer: Mozilla 3.01Gold (Win95; I)
MIME-Version: 1.0
Subject: Re: JConnect Connection Speed
References: <33AF2132.1AA8@dnai.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 28
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:632
Article PK: 252385

Right now the best thing I can suggest is that you install a second web
server (of your choice) on the SQL Server machine. Use the web server
on the other machine for most of your web work but when you need to
connect to the SQL Server use the web server on the SQL Server machine.

The Cascade HTTP Gateway is written in Java and there will be
improvements in speed when Sun releases the Just In Time compiler for
UNIX and also when they map to native threads. Hopefully this will be
available in a few months.

Regards,
Mary Peek, Sybase

> We have developed a test application using JConnect and benchmarked the
> performance. The query speed sounds fine for us, but the Sybase
> connection takes 30-40 seconds, which is unacceptable in our
> application. The JDBC version we are using is 1.02. Since our web server
> and database server are on different machine, applets connect to
> database trhough Casecade HTTP Gateway. Our company Intranet is on T1
> line. May I know how we could speed up the connection? It will affect
> our purchase decision.