Database Programming, Performance issues - WebLogic JDBC driver to MS-SQL

Partha Dut
#1 / 7

Performance issues - WebLogic JDBC driver to MS-SQL

I have a program that is trying to execute numerous INSERTs into an
SQL Server database via the WebLogic MS-SQL type 4 driver. The code
runs on a UNIX system. It seems horribly slow, about 210 records per
minute. Is there some sort of setting that I am missing? I vaguely
remember a setting in the ODBC manager to create stored procedures
from prepared statements. Is there something equivalent on the JDBC
end? I am preparing the statements & executing.

Partha Dutta

Mon, 04 Jun 2001 03:00:00 GMT

Mark Thornt
#2 / 7

Performance issues - WebLogic JDBC driver to MS-SQL

Quote:

> I have a program that is trying to execute numerous INSERTs into an
> SQL Server database via the WebLogic MS-SQL type 4 driver. The code
> runs on a UNIX system. It seems horribly slow, about 210 records per
> minute. Is there some sort of setting that I am missing? I vaguely
> remember a setting in the ODBC manager to create stored procedures
> from prepared statements. Is there something equivalent on the JDBC
> end? I am preparing the statements & executing.

> Partha Dutta

Are you using a prepared statement and if so how many parameters are you
passing? I have found that driver extremely slow when the number of
parameters on a prepared statement exceeds about 8 (depending on parameter
type). Below the limit a statement takes <10ms to run, above the limit it
takes 200ms. The extra time is just spent waiting (CPU utilisation falls
dramatically). I am now using another driver which gives me around 700
inserts per second.

Mark Thornton

Mon, 04 Jun 2001 03:00:00 GMT

Dirk P. Fromhei
#3 / 7

Performance issues - WebLogic JDBC driver to MS-SQL

Using our Relational Object Framework (ROF) and the Weblogic Type 2
(dblib) driver we can get over 500 rows/sec on a reasonably slow machine
(Server is a PII 233 NT 4.0 MS SQL 6.5- IDE drive, client a Sparc Ultra)

We have not done a formal comparison with the type 4 driver though.

Good luck,
Dirk
http://www.watershed.com

Quote:

> I have a program that is trying to execute numerous INSERTs into an
> SQL Server database via the WebLogic MS-SQL type 4 driver. The code
> runs on a UNIX system. It seems horribly slow, about 210 records per
> minute. Is there some sort of setting that I am missing? I vaguely
> remember a setting in the ODBC manager to create stored procedures
> from prepared statements. Is there something equivalent on the JDBC
> end? I am preparing the statements & executing.

> Partha Dutta

Dirk.Fromhein.vcf
< 1K Download

Mon, 04 Jun 2001 03:00:00 GMT

Greg Vilar
#4 / 7

Performance issues - WebLogic JDBC driver to MS-SQL

Quote:

>> I have a program that is trying to execute numerous INSERTs into an
>> SQL Server database via the WebLogic MS-SQL type 4 driver. The code
>> runs on a UNIX system. It seems horribly slow, about 210 records per
>> minute. Is there some sort of setting that I am missing? I vaguely
>> remember a setting in the ODBC manager to create stored procedures
>> from prepared statements. Is there something equivalent on the JDBC
>> end? I am preparing the statements & executing.

>> Partha Dutta

>Are you using a prepared statement and if so how many parameters are you
>passing? I have found that driver extremely slow when the number of
>parameters on a prepared statement exceeds about 8 (depending on parameter
>type). Below the limit a statement takes <10ms to run, above the limit it
>takes 200ms. The extra time is just spent waiting (CPU utilisation falls
>dramatically). I am now using another driver which gives me around 700
>inserts per second.
>Mark Thornton

If you don't mind our asking, which driver?

--

USnail: 354 Indian Head Rd|In-Touch Management Systems | Home:(516)864-1310
Commack, NY 11725 |Melville, NY 11747 | Work:(516)752-2701x240
.sig Version 0.50(beta release) I thought, I wrote, I posted.

Mon, 04 Jun 2001 03:00:00 GMT

Tim Leah
#5 / 7

Performance issues - WebLogic JDBC driver to MS-SQL

Hello,
I don't know if this helps but I'm using the weblogic classes
in an applet that connects directly to a SQL Server database. I
get seven ResultSet from the DB and it takes about 30 seconds on
average over a 28.8 connection. I'm only reading from not writing
to the DB so I'm not sure if the time it takes is because of that
or if the wait is normal. Hope that helps.

Tim Leahy

Mon, 04 Jun 2001 03:00:00 GMT

Mark Thornt
#6 / 7

Performance issues - WebLogic JDBC driver to MS-SQL

Quote:

> If you don't mind our asking, which driver?

We wrote it ourselves. It is a type 2 driver using ODBC, but only actually
works with SQL Server (it has lots of workarounds for SQL Server
'features'). Although we have implemented much of JDBC 2, there are
certainly some omissions.

Mark Thornton
Optrak Distribution Software Ltd.

Mon, 04 Jun 2001 03:00:00 GMT

Joseph Weinstei
#7 / 7

Performance issues - WebLogic JDBC driver to MS-SQL

Hi. If you send me an example of you code, I may be able to
show you ways of speeding it up.
Joe

Quote:

> I have a program that is trying to execute numerous INSERTs into an
> SQL Server database via the WebLogic MS-SQL type 4 driver. The code
> runs on a UNIX system. It seems horribly slow, about 210 records per
> minute. Is there some sort of setting that I am missing? I vaguely
> remember a setting in the ODBC manager to create stored procedures
> from prepared statements. Is there something equivalent on the JDBC
> end? I am preparing the statements & executing.

> Partha Dutta

--
BEA WebLogic: Voted The Best Web Application Server: JAVAWORLD
http://java.sun.com/events/jbe/98/features/ed.choice.html
BEA with WebLogic in the 12 most influential IT companies:
http://www.intelligententerprise.com/98dozen/frm_feat1.shtml

Mon, 04 Jun 2001 03:00:00 GMT