Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^4: Sybase DB Library vs Client Library API

by perl@1983 (Sexton)
on Aug 03, 2012 at 08:28 UTC ( #985184=note: print w/ replies, xml ) Need Help??


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

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.


Comment on Re^4: Sybase DB Library vs Client Library API
Re^5: Sybase DB Library vs Client Library API
by mpeppler (Vicar) on Aug 22, 2012 at 06:12 UTC
    Hi,

    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.)

    Michael

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (12)
As of 2014-08-29 19:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (287 votes), past polls