Article:		Relational Modeling of Biological Data: Trees and Graphs
Subject:		fetch() without execute() error in Example 1
Date:		2004-01-11 11:31:44
From:		anonymous2
Response to: fetch() without execute() error in Example 1
It took several days(more than a week) on a pentium-4 freebsd machine to run this code for entire ncbi taxonomy. Is there anything I should check with my MySql or table structure? I have indexed the taxon_id and the parent_id.

Showing messages 1 through 1 of 1.

• fetch() without execute() error in Example 1
  2006-02-06 10:55:01  Aaron Mackey | [View]
  
  
  The $children statement needs an additional clause, as follows:
  
  
my $children = $dbh->prepare("SELECT id
FROM taxon
WHERE parent_id = ?
AND id <> parent_id");