search

oicr-ibc / heliotrope

Other
10 stars 0 forks source link

Fix query plan in Heliotrope::Update::Ensembl #43

Closed morungos closed 10 years ago

morungos commented 10 years ago 
 say "Finding RefSeq identifiers.";

 $statement = $dbh->prepare(<<__ENDSQL__) or die($dbh->errstr());

SELECT g.id, tr.stable_id, x.display_label -FROM external_db xdb -CROSS JOIN interesting_genes g +FROM interesting_genes g JOIN transcript tr ON tr.gene_id = g.gene_id JOIN object_xref ox ON ox.ensembl_id = tr.transcript_id AND ox.ensembl_object_type = 'Transcript' -JOIN xref x on x.xref_id = ox.xref_id AND x.external_db_id = xdb.external_db_id +JOIN xref x on x.xref_id = ox.xref_id +JOIN external_db xdb ON x.external_db_id = xdb.external_db_id WHERE xdb.db_name = 'RefSeq_mRNA' ORDER BY g.id ASC, tr.stable_id ASC, x.display_label ENDSQL

morungos commented 10 years ago

Closing. Performance is fine.