Slow response time from Java compared to Query Analyzer

From: Utkarsh Mohta (umohta_at_mmm.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 13:02:14 -0800

Hi,
I have an application in Java WSAD 5.1 which uses the SQL Server
database. I use the microsoft jdbc type 4 driver.
The query execution time for a particular query is 800 MS from the java
program while in SQL query analyzer it is 100 MS.
I am using prepared statement in my query from Java.

I am already setting the datasource parameter
sendStringParametersAsUnicode to false

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: dynamic type checking - a pauline conversion?
    ... to actually write the code in Java. ... Is the query handled ... One of the problems with Java typing is small differences in interfaces ... array iteration, List iteration, and database query result iteration all ...
    (comp.object)
  • RE: Slow response time from Java compared to Query Analyzer
    ... Slow response time from Java compared to Query Analyzer ... Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Cant get JDBC to work from Java to MySQL
    ... ResultSet rs = stat.executeQuery("SELECT draw_date FROM ... (Java, Stack trace, and table description - stack trace from the code ... compiles and prints! ... SQL Exception:Unexpected exception encountered during query. ...
    (comp.lang.java.programmer)
  • Re: Query LDAP from Linux??
    ... > I have a developer that wants to be able to query AD ... > using a Java based Linux app, what to I need to tell him ... have to explicitly send a bind request with the DN of a domain account. ... This should be no problem with any Java LDAP API ...
    (microsoft.public.windows.server.active_directory)
  • Re: Selecting Multivalues
    ... association to exist in the file and in the query, ... JavaScript; or those writing VB who are asked to write Java. ... distinguish between an empty dynamic array, ...
    (comp.databases.pick)