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

[Hilmar L. <hl...@ne...>]

And can you submit this as a bug on Sf.net please?

	-hilmar

On Feb 8, 2010, at 3:37 PM, Jon Auman wrote:

> 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...
> ------------------------------------------------------
>
>
>
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the  
> business
> Choose flexible plans and management services without long-term  
> contracts
> Personal 24x7 support from experience hosting pros just a phone call  
> away.
> http://p.sf.net/sfu/theplanet-com_______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel

-- 
===========================================================
: Hilmar Lapp  -:- Durham, NC -:- informatics.nescent.org :
===========================================================