PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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...