Skip to main content
Question

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


Forum|alt.badge.img+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

david_r
Evangelist
  • April 23, 2019

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


Forum|alt.badge.img+3
david_r wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings