Question

Special Step to engage Excel Reader's Bulk Mode in 2019.0?


Badge +3

Hello! I understand in 2019.0 the Excel Reader makes use of bulk-mode. However, I find it only to be marginally faster than 2018.1 when reading in the same large .xlsx file (9 min. 27 sec in 2019.0 vs 10 min. 53 sec in 2018.1). I have tried creating the reader from scratch in 2019.0. Is there a special step that needs to be done in order to engage bulk-mode? BTW, for 2019.0 I'm on build 19238. Thanks in advance!


2 replies

Userlevel 5

Are you sure that the timings are not influenced by whatever transformer is used after the reader? Not all transformers support bulk mode (yet).

Badge +3

Are you sure that the timings are not influenced by whatever transformer is used after the reader? Not all transformers support bulk mode (yet).

Great question! I am just doing a simple read then nothing else, for purposes of a speed test.

Reply