Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: softfail (athena.apache.org: transitioning domain of
 lou.degenaro@gmail.com does not designate 216.139.236.26 as permitted sender)
Date: Wed, 8 Jan 2014 05:16:09 -0800 (PST)
From: degenaro <lou.degenaro@gmail.com>
To: derby-user@db.apache.org
Message-ID: <1389186969882-136343.post@n7.nabble.com>
In-Reply-To: <52CCA2D4.5010009@gmail.com>
References: 
 <CA+W_RZhTNSdAhjHeF3pjdfJHwmWE4y=WC65eNq=Zwr4xj5u8Vw@mail.gmail.com>
 <52C9962D.60903@gmail.com> <1389020047133-136295.post@n7.nabble.com>
 <52CB524D.4000504@gmail.com> <1389103713258-136320.post@n7.nabble.com>
 <52CC1A3D.4040300@gmail.com> <1389127928415-136327.post@n7.nabble.com>
 <52CCA2D4.5010009@gmail.com>
Subject: Re: slow query? (from a practical newbie)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Bryan Pendleton-3 wrote
> In both cases, I'm wondering if somehow the problem is in the output
> phase, like there's a huge amount of output because there's a BLOB
> column in your table or something like that, or the client side is
> just taking an eternity to process the output.

I can try, but I doubt the volume of data is the issue since the where
clause lessens the amount produced.

Lou.


--
View this message in context: http://apache-database.10148.n7.nabble.com/slow-query-from-a-practical-newbie-tp136285p136343.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.