Performance issues - WebLogic JDBC driver to MS-SQL 
Author Message
 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
 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
 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
 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
 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
 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
 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
 
 [ 7 post ] 

 Relevant Pages 

1. MS JDBC Driver Performance Issues

2. MS JDBC Driver Performance Issues

3. MSSQL / Weblogic JDBC driver problem

4. MS-SQL 2000 JDBC Driver issues with IBM WebSphere

5. Connections Piling up using WebLogic JDBC Driver in conjunction with SQL Server 7.0

6. JDBC Driver for MS Access (Not JDBC-ODBC Driver)

7. This driver versus Weblogic.jdbc.mssqlserver4.Driver

8. Maximum cursors exceeded (weblogic oracle jdbc drivers)

9. jdbc driver: weblogic

10. Does JDBC driver from MS work with MS SQL 7.0

11. MSSQL 7 & MS SQL JDBC Driver


 
Powered by phpBB® Forum Software