Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.programmer > #14775

Re: Extract String and StringBuffer

From Robert Klemme <shortcutter@googlemail.com>
Newsgroups comp.lang.java.programmer
Subject Re: Extract String and StringBuffer
Date 2012-05-24 08:20 -0700
Organization http://groups.google.com
Message-ID <38ee8208-ce14-4ff8-b199-a79c0f5831b9@googlegroups.com> (permalink)
References <34c76a08-4bdb-462b-9178-c8a24d9a5dba@googlegroups.com> <fuudnas749CBZCDSnZ2dnUVZ8h2dnZ2d@giganews.com> <54c296d1-7913-45f0-b1f1-a602a0c34cbf@googlegroups.com>

Show all headers | View raw

On Thursday, May 24, 2012 12:21:46 PM UTC+2, mikew01 wrote:
> The requirement is to pull out the sql statements and profile them using the Oracle explain plan which will be executed by Sonar.

Plans can vary dramatically depending on data.  How do you want to deal with that, especially if SQL statements are created using StringBuilder?  Where do you get the data from which you use in your test case?

Also creation of a single statement can be spread across different methods.  That'll be difficult to resolve.


It's probably better to benchmark the application while enabling one of the Oracle traces during execution.  You'll then get the real data and execution plans.  For production usage the point in time when statistics are updated is also an important factor.  That might be difficult to properly test in the lab if you only have those SQL statements (assumed you can recover them from the source).

Kind regards

robert

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

Thread

Extract String and StringBuffer mikew01 <mikew01@blueyonder.co.uk> - 2012-05-24 01:29 -0700
  Re: Extract String and StringBuffer Leif Roar Moldskred <leifm@dimnakorr.com> - 2012-05-24 04:02 -0500
    Re: Extract String and StringBuffer mikew01 <mikew01@blueyonder.co.uk> - 2012-05-24 03:21 -0700
      Re: Extract String and StringBuffer markspace <-@.> - 2012-05-24 08:21 -0700
        Re: Extract String and StringBuffer Roedy Green <see_website@mindprod.com.invalid> - 2012-05-28 09:28 -0700
          Re: Extract String and StringBuffer markspace <-@.> - 2012-05-28 12:19 -0700
      Re: Extract String and StringBuffer Robert Klemme <shortcutter@googlemail.com> - 2012-05-24 08:20 -0700
        Re: Extract String and StringBuffer markspace <-@.> - 2012-05-24 08:47 -0700
          Re: Extract String and StringBuffer Lew <lewbloch@gmail.com> - 2012-05-24 09:52 -0700
      Re: Extract String and StringBuffer Martin Gregorie <martin@address-in-sig.invalid> - 2012-05-24 20:29 +0000
  Re: Extract String and StringBuffer Roedy Green <see_website@mindprod.com.invalid> - 2012-05-28 09:29 -0700

csiph-web