Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: soup at ampersand dot com (Doug Campbell)
Subject: Re: BCP module
Date: Feb 16 1996 4:40PM

] Date: Fri, 16 Feb 96 15:48:00 +0100
] From: mpeppler@itf.CH (Michael Peppler)
] 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've written and been maintaining for 4 years some sybperl software
that parses ASCII formatted input files and does BCP loads from them.
I've found that Sybase can always suck in BCP much faster that I can
parse the input and feed it.  In fact, I can't seem to get the perl
parsing to go any better than about 4-6 times slower than the Sybase
BCP.  The parsing involves field rearranging, field validity checking,
and callbacks for computed values, and other stuff.  Sound familiar?

I look forward to Michael's efforts, particularly if I can get my
stuff working any faster as a result.

					Doug Campbell