Groups > comp.lang.java.databases > #588

Re: Query performance

From	"John B. Matthews" <nospam@nospam.invalid>
Newsgroups	comp.lang.java.databases
Subject	Re: Query performance
Date	2013-04-05 09:30 -0400
Organization	The Wasteland
Message-ID	<nospam-9F4735.09303805042013@news.aioe.org> (permalink)
References	<02ee34f7-b22a-4704-b504-4b24920092a3@googlegroups.com>

Show all headers | View raw

In article <02ee34f7-b22a-4704-b504-4b24920092a3@googlegroups.com>,
 thomas.lehmann@adtech.com wrote:

> using a very simple Java application I've connected to a database 
> that is Oracle. The code just uses standard JDBC handling like 
> Connection, Statement and ResultSet.
> 
> Now ...
> 
> A very specific SQL statement takes about 250ms just providing an ID. 
> Using "SQuirrel" or "SQL Plus" as clients exactly the same query 
> takes 5ms.
> 
> SQuirrel is in Java and - so far I have seen - the same JDBC handling 
> has been taken as I did. For Squirrel to say: I have been using the 
> same Oracle (thin) driver and same connection parameter (for sure).
> 
> So what might be the reason for the performance problem?

What does your profiler say? jvisualvm may already be installed.

> Does somebody has an idea?

See "Java theory and practice: Anatomy of a flawed microbenchmark":

<http://www.ibm.com/developerworks/java/library/j-jtp02225/index.html>

-- 
John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Query performance thomas.lehmann@adtech.com - 2013-04-05 04:16 -0700
  Re: Query performance "John B. Matthews" <nospam@nospam.invalid> - 2013-04-05 09:30 -0400
  Re: Query performance David Kerber <dkerber@WarrenRogersAssociates.invalid> - 2013-04-11 08:18 -0400
  Re: Query performance Roedy Green <see_website@mindprod.com.invalid> - 2013-04-15 11:58 -0700
    Re: Query performance Martin Gregorie <martin@address-in-sig.invalid> - 2013-04-15 22:05 +0000
      Re: Query performance Arne Vajhøj <arne@vajhoej.dk> - 2013-04-15 21:14 -0400
    Re: Query performance Arne Vajhøj <arne@vajhoej.dk> - 2013-04-15 21:12 -0400
    Re: Query performance Lew <lewbloch@gmail.com> - 2013-04-15 19:01 -0700
  Re: Query performance Martin Gregorie <martin@address-in-sig.invalid> - 2013-04-15 21:39 +0000
  Re: Query performance Arne Vajhøj <arne@vajhoej.dk> - 2013-04-15 21:18 -0400
  Re: Query performance Harry Tuttle <SOZRBLNTLEEE@spammotel.com> - 2013-04-16 14:59 +0200

csiph-web