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: 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
					soup@ampersand.com