Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Sybase::BCP vs. CTlib

by mpeppler (Vicar)
on Nov 28, 2001 at 22:05 UTC ( [id://128116]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Re: Perl with Sybase: sybperl or DBI/DBD::Sybase?
in thread Perl with Sybase: sybperl or DBI/DBD::Sybase?

The Sybase BCP api is indeed limited with respect to certain datatypes, and cannot be used to load data to a table that does not use allpages locking.

sybperl 2.13_10 (a test release, available from http://www.peppler.org/downloads/) includes a new Sybase::BLK module, which is based on some new blk_*() calls in the Sybase::CTlib module. I suggest that you give that a try.

As for having bulk-loading available in DBI - it's an interesting idea, but you will almost always get much better speed by creating a load file and calling the database server's bulk-loading utility (like Sybase's bcp command) due to overhead in moving data around in perl.

I'm looking into ways of improving that, btw, but for now the overhead of using Sybase::BCP or Sybase::BLK is significant.

Michael

Replies are listed 'Best First'.
Re: Sybase::BCP vs. CTlib
by Ravi V (Scribe) on Nov 20, 2012 at 14:13 UTC
    have converted some of my perl scripts to use CTlib blk instead of DBlib bcp ... but i am facing problem with memory usage(increased)... Is there any document on CTlib memory usage? It would be great help... thanks in advance

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://128116]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (3)
As of 2025-06-14 14:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.