I was puzzled by your socket connection sub. First, either you aren't using strict, or else there's a (global?) declaration for the variable "$return" that you aren't showing. Second, you do a "return $return;" followed by an "if(...)" -- and of course the "if" statement can never be reached.

That might not have anything to do with your problem, but if you add "use strict;" and clean things up, the real problem might be revealed. BTW, I notice that the "doSQL" sub refers to $usingDB, which not passed to or declared within the sub. This is generally considered poor form. It's better for the sub to be fully self-contained, not referring to any globals outside its own scope. (And anyway, if $usingDB is false, this sub shouldn't have been called in the first place.)

As for database performance, perhaps you can figure out a way to use a consistent sql statement with placeholders, such that a given statement only needs to be prepared once per run connection (I presume there's one connection per run). Something like this: 

sub doSQL
{
    my ( $tablename, $fldnames, $fldvals ) = @_;  # change call params
+:
           # string, array_ref, array_ref

    my $sqlstring = "insert into $tablename (", join( ',', @$fldnames 
+) .
        ') values (' . join( ',', ('?') x scalar @$fieldnames ) . ')';

    my $sth = $dbh->prepare_cached( $sqlstring );
    $sth->execute( @$fldvals );

    # add error checking as desired...
}

[download]
(updated to fix a misspelled variable name)

You'll probably want to read the section in the DBI manual about the "prepare_cached" function.

In reply to Re: MySQL DBI an Socket::IO dropping inserts somewhere by graff
in thread MySQL DBI an Socket::IO dropping inserts somewhere by whiteonline

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.