Re^2: DBI: How to update 150K records efficiently


good chemistry is complicated, and a little bit messy -LW
	PerlMonks

Re^2: DBI: How to update 150K records efficiently

by lihao (Monk)

on Mar 31, 2008 at 15:13 UTC ( [id://677559]=note: print w/replies, xml )

Need Help??

in reply to Re: DBI: How to update 150K records efficiently
in thread DBI: How to update 150K records efficiently

Thanks all for the helpful replies. :-)I've adjusted my code to:

my $sql = qq[
    UPDATE `myTable` 
    SET `va` = ?, `vb` = ? 
    WHERE `vc` = ?
];
while (my $record = <$input>)
{
    chomp $record;
    my ($val1, $val2, $val3) = (split(/\|/,$record))[1,3,5];
    $db->query($sql, $val1, $val2, $val3);
}
[download]

My question is: can we get the same 'prepare' effects as moritz mentioned in his post, since 'prepare' is done before the while loop..:)

BTW. thank you for your module, I've used it in most of my applications.

Best,
lihao

Comment on Re^2: DBI: How to update 150K records efficiently Download Code

Replies are listed 'Best First'.
Re^3: DBI: How to update 150K records efficiently by Juerd (Abbot) on Mar 31, 2008 at 15:22 UTC
My question is: can we get the same 'prepare' effects as moritz mentioned in his post, since 'prepare' is done before the while loop..:) That is done automatically. DBIx::Simple recognises that the query is the same each time, and re-uses the old statement handle that represents the already compiled query. Juerd # { site => 'juerd.nl', do_not_use => 'spamtrap', perl6_server => 'feather' }	[reply]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://677559]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others avoiding work at the Monastery: (5)

As of 2024-04-24 08:16 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found