Re^4: Sybase DB Library vs Client Library API

[perl@1983]

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.

[mpeppler]

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