Monktim, I'm trying to work your code into mine and I'm having some
problems any help would be appreciated. Here's what I tried:
my $orf_id = $pt->get("$i,2");
#$dbh->do(q{ CREATE TEMPORARY TABLE IF NOT
EXISTS
moo(id INT UNSIGNED, escore DOUBLE, org_id
MEDIUMINT)});


$sql1 = qq/ SELECT DISTINCT min(escore) as escore,
org_id
FROM blast, protein
WHERE EXISTS ( SELECT id2, escore, org_id2
FROM blast, protein
WHERE id1 = id
AND text_id = ?
UNION
SELECT id1, escore, org_id1
FROM blast, protein
WHERE id2 = id
AND text_id = ? )
GROUP BY org_id
/;
$sth2->prepare($sql1);
$sth2->execute($orf_id);
with the above I got the following error:

Background Error: Can't locate object method "prepare" via package "DBI::st" (p rhaps you forgot to load "DBI::st"?) at C:/Perl/site/lib/RG/PropTable.pm line 1 75.
I've inhereted the code and a novice at best.
Any ideas on where the problem is?
Thanks,
Mark

In reply to Re: Re: speeding up mySQL query in .pm by Anonymous Monk
in thread speeding up mySQL query in .pm by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.