[Treebase-devel] Bad query in treebase-web app?

[Jon A. <jon...@ne...>]

When  I click on 'trees' for a larger dataset such as 'oak' I get the following query in postgresql:

select phylotree0_.PHYLOTREE_ID as PHYLOTREE1_60_, phylotree0_.VERSION as VERSION60_, phylotree0_.TB1_TREEID as TB3_60_, phylotree0_.BigTree as BigTree60_, phylotree0_.Label as Label60_, phylotr
e0_.ntax as ntax60_, phylotree0_.NewickString as NewickSt7_60_, phylotree0_.NexusFileName as NexusFil8_60_, phylotree0_.Published as Published60_, phylotree0_.ROOTNODE_ID as ROOTNODE12_60_, phylotree0_.RootedTree as RootedTree60_, phylotree0_.STUDY_ID as 
TUDY13_60_, phylotree0_.Title as Title60_, phylotree0_.TREEATTRIBUTE_ID as TREEATT14_60_, phylotree0_.TREEBLOCK_ID as TREEBLOCK15_60_, phylotree0_.TREEKIND_ID as TREEKIND16_60_, phylotree0_.TREEQUALITY_ID as TREEQUA17_60_, phylotree0_.TREETYPE_ID as TREET
PE18_60_ from PHYLOTREE phylotree0_, TAXONLABEL taxonlabel1_, TAXONVARIANT taxonvaria6_ where taxonlabel1_.TAXONVARIANT_ID=taxonvaria6_.TAXONVARIANT_ID and (taxonlabel1_.TAXONLABEL_ID in (select taxonlabel5_.TAXONLABEL_ID from TREEBLOCK treeblock2_ inner 
oin TaxonLabelSET taxonlabel3_ on treeblock2_.TAXONLABELSET_ID=taxonlabel3_.TaxonLabelSET_ID, TaxonLabelSET_TaxonLabel taxonlabel4_, TAXONLABEL taxonlabel5_ where phylotree0_.TREEBLOCK_ID=treeblock2_.TREEBLOCK_ID and taxonlabel3_.TaxonLabelSET_ID=taxonlab
l4_.TaxonLabelSET_ID and taxonlabel4_.TaxonLabel_ID=taxonlabel5_.TAXONLABEL_ID)) and taxonvaria6_.TAXON_ID=$1


Look at the tail end of the query
TAXON_ID=$1
Can that be right ??? 

I pulled this query directly off the postgresql server from the command line. The query hangs and never finishes, even if I let it run for hours.

It seems to me to be an application error, and not necessarily a need for indexes specifically.

-Jon

-------------------------------------------------------
Jon Auman
Systems Administrator
National Evolutionary Synthesis Center
Duke University
http:www.nescent.org
jon...@ne...
------------------------------------------------------