Re: Re: Batch DB query -- implementation?

Replies are listed 'Best First'.
Re: Re: Re: Batch DB query -- implementation? by perrin (Chancellor) on Jul 03, 2002 at 15:59 UTC
Are you using bind variables? I believe that will reduce the amount of data sent over the network.	[reply]
Re: Re: Re: Re: Batch DB query -- implementation? by zaimoni (Beadle) on Jul 03, 2002 at 16:07 UTC
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]
Re(4): Batch DB query -- implementation? by perrin (Chancellor) on Jul 03, 2002 at 16:28 UTC
That's correct, you are using bind variables. Another way to do it, if you really find that network is killing you, is to use whatever batch loader your database provides and just have perl generate the correct file format to feed it.	[reply]