in reply to Batch DB query -- implementation?

I seriously doubt that the network communication is slowing you down much here. I've inserted hundreds of thousands of rows in seconds with DBI. You might do better to tune your database instead of worrying about this.

Replies are listed 'Best First'.
Re: Re: Batch DB query -- implementation?
by zaimoni (Beadle) on Jul 03, 2002 at 15:54 UTC
    The network connection for the MS SQL Server is IP. Ping time from my location is between 160 and 220 ms.
[reply]
      Are you using bind variables? I believe that will reduce the amount of data sent over the network.
[reply]
        Bind variables:
        Sorry, my terminology is weak here: I wouldn't know whether I was using bind variables even if I was. What I know is that I'm currently using '?' as a place holder so that I don't have to think about properly escaping the data. My current paradigm is: 
        my $sth = $dbh->prepare($query)
$sth->execute(@parameterlist)

        [download]
        (use looping as convenient).
[reply]
[d/l]

In Section Seekers of Perl Wisdom