|
|
sybperl-l Archive
Up Prev Next
From: gabe at sio dot ucsd dot edu (Gabriel Lawrence)
Subject: Re: BCP module
Date: Feb 16 1996 4:13PM
> One of the problems is speed. My initial implementation is approx 4x
> slower than pure bcp (though I was running perl and the Sybase server
> on the same machine, so cpu contention was high). But if you need to
> munge the data before sending it into the dataserver then the speed
> issue is less important - you still have process the datafile, which
> will take time.
I have to say that having a programmatic way to process the data and bcp it
up would be extremely handy!
> Is that very different from writing:
>
> $dbh->dbcmd("select * from table where $condition");
> $dbh->dbsqlexec; $dbh->dbresults;
> $, = '|'; # I want to use | as field separator...
> while(@dat = $dbh->dbnextrow) {
> print "@dat\n";
> }
>
> I could always put that in somewhere...
it would be nice to have the same api to copy in as copy out...
|
