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
Celebrity
  • 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.


Reply


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