Bryan,
I´ve downloaded derby 10.3.1 and executed the query, but unfortnuately
its still taking a lot of time (20 secs). I wanted to send the query
plan in this mail, but its currently being written in portuguese.
Does anybody know how to change the default language debry its using to
write the query plan?
Thanks,
Francisco
Bryan Pendleton escreveu:
pesagens1_.PESAGEM_ID=pesagem2_.PESAGEM_ID where (animal0_.ANIMAL_ID in
( ... 800 ids ...))
Quite possibly, you are being affected by DERBY-47:
http://issues.apache.org/jira/browse/DERBY-47
Since we believe that this problem has been fixed in Derby 10.3,
it would be wonderful if you could download the DERBY 10.3 beta
release from http://wiki.apache.org/db-derby/DerbyTenThreeRelease
and give it a try to see how it affects your query.
thanks,
bryan
P.S. Myrna, I noticed that it was a bit hard to find a good
hyperlink to the beta release. Perhaps you could put a
link to the 10.3 beta on http://db.apache.org/derby/
and/or http://db.apache.org/derby/derby_downloads.html
as those would be natural places to look? Or are we
not supposed to do that because it's still a beta release?
--
Francisco Trindade
[EMAIL PROTECTED]
M3Tech - Tecnologia para o Agronegócio
www.m3tech.com.br
