S
Stefan Marquardt
Guest
I compared the time of using "export" or create it dynamically with abl to create a correct format for sql bcp load. ABL export method needs currenty for a full dump 30 minutes, the same with ABL code to create the string with some small checks 5 hours. The string functions in ABL seems to be very slow, in C# there is a stringbuilder with a good performance. So wie decided to use the "fast" ABL export command (with temp .p files dynamically generated for every table) and fast string conversion function in C# with many threads which use 100% of every CPU.
Continue reading...
Continue reading...