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.