Women in Technology

Hear us Roar



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.
Full Threads Oldest First

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");