Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: Re: Re: Perl with Sybase: sybperl or DBI/DBD::Sybase?

by Gyro (Monk)
on Nov 28, 2001 at 04:37 UTC ( #127965=note: print w/replies, xml ) Need Help??

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


As I mentioned, Sybase::BCP is one I rely on, coupled with DBlib I use it to do all my data transfers. The two are well suited since BCP is based on DBlib. My concern lies with the changes in the Sybase client i.e., how does BCP match up with the changes in datatypes? This is something we havenít had to deal with yet. It would seem there would be some issues there. Would feel more comfortable to see CTlib have full access to the BCP API. But that seems more of a Sybase issue.
As far as DBI is concerned, if in the future it also could have access to the BCP API. I move a lot of data. With the ability to pluggin to different DBMSí it would be an added bonus to move data in bulk from one platform to another, using the appropriate bulkload APIís.


  • Comment on Re: Re: Re: Perl with Sybase: sybperl or DBI/DBD::Sybase?

Replies are listed 'Best First'.
Sybase::BCP vs. CTlib
by mpeppler (Vicar) on Nov 28, 2001 at 22:05 UTC
    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 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.


      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?

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (2)
As of 2018-08-18 01:11 GMT
Find Nodes?
    Voting Booth?
    Asked to put a square peg in a round hole, I would:

    Results (184 votes). Check out past polls.