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

Re: Query performance

From	Roedy Green <see_website@mindprod.com.invalid>
Newsgroups	comp.lang.java.databases
Subject	Re: Query performance
Organization	Canadian Mind Products
Message-ID	<v8jom8hrvb887ep7fr3teuljqiebqtpd0b@4ax.com> (permalink)
References	<02ee34f7-b22a-4704-b504-4b24920092a3@googlegroups.com>
Date	2013-04-15 11:58 -0700

Show all headers | View raw

On Fri, 5 Apr 2013 04:16:56 -0700 (PDT), thomas.lehmann@adtech.com
wrote, quoted or indirectly quoted someone who said :

>
>Does somebody has an idea?

If you have a performance problem, first thing is to use a prepared
statement.

Also give it a chance to "warm up" fill caches, glean data to optimise
etc. 

Next, analyse it the way we did back in the 1970s, figuring out how
the head moves on the typical transaction.  Then you think about how
to reduce the number of i/os, position the files, use multiple drives,
SSDs etc.  You can sometimes change the order of the work of a
transaction.
-- 
Roedy Green Canadian Mind Products http://mindprod.com
Computer programming is the best remedy for pain (physical or emotional) 
I have encountered. It requires so much concentration there is nothing left 
over to pay attention to the pain. They should teach this in AA.

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