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]
$childrenstatement needs an additional clause, as follows:my $children = $dbh->prepare("SELECT id
FROM taxon
WHERE parent_id = ?
AND id <> parent_id");