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

Re^3: Sybase DB Library vs Client Library API

by mpeppler (Vicar)
on Aug 02, 2012 at 15:35 UTC ( #985055=note: print w/replies, xml ) Need Help??

in reply to Re^2: Sybase DB Library vs Client Library API
in thread Sybase DB Library vs Client Library API

Same as roboticus, really - the DBI syntax is a little simpler, and the API is (mostly) standardized, so your scripts can be easily maintained by someone else who doesn't necessarily understand the CTlib API.

And I'm more likely to fix things in DBD::Sybase these days...


  • Comment on Re^3: Sybase DB Library vs Client Library API

Replies are listed 'Best First'.
Re^4: Sybase DB Library vs Client Library API
by perl@1983 (Sexton) on Aug 03, 2012 at 08:28 UTC
    Thanks Michael. My team is working on migrating our scripts from DBlib (to either CTlib or DBD::Sybase). However, we are still discussing the pros and cons of CTlib vs DBD::Sybase. One of the things we noticed was the bcp in CTlib is much much faster as compared to the "Experimental Utility" in DBD::Sybase. Can you please help to clarify whether the "Experimental Bulk Load" utility in DBD::Sybase is doing inserts underlyingly and therefore slower? Thanks much.

      No, DBD::Sybase uses the same BLK API as Sybase::CTlib, so it should theoretically be as fast (though to be honest I haven't timed them.)


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://985055]
[1nickt]: ugh, buying a computer is hard for an old person
[stevieb]: How do you mean?
[1nickt]: They assume that I want things I don;t and don;t provide things I do want. Looking for a 17" laptop with 4k (even 3K display) and full numeric-pad keyboard.

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (6)
As of 2017-03-26 17:58 GMT
Find Nodes?
    Voting Booth?
    Should Pluto Get Its Planethood Back?

    Results (315 votes). Check out past polls.