|
|
sybperl-l Archive
Up Prev Next
From: michael dot peppler at bnpparibas dot com
Subject: Re: blk out
Date: Apr 12 2005 6:02AM
[ sorry for top-posting... damn Lotus Notes... ]
A couple of points...
a) Native support is feasible, but would probably require a fair amount of
work internally as Sybase::CTlib
currently converts incoming data to a subset of Sybase native datatypes.
b) bcp out using the bcp binary is bound to be quite a bit faster than a
select executed with a perl script,
but most of the difference is in the perl data processing (AFAIK)
c) agreed :-)
That being said.... "patches welcome" as I don't really have the time to
work on new features
right now.
Michael
Internet
Stephen.Sprague@MorganStanley.com@peppler.org - 11/04/2005 21:23
Sent by: owner-sybperl-l@peppler.org
To: sybperl-l
cc:
Subject: blk out
Hi Michael-
what are your thoughts on a bcp *out* api in perl? before you jump and say
its just
a select -- it's not quite in my observations.
a) no native (-n) support with select
b) bcp out (-c) is much faster than select - at least that's what I'm
seeing
c) sure would be nice to get rowcounts and error messages
from a handler/api rather than parsing bcp out output.
as always thanks,
Steve
This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.
---------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
|
