Skip to main content
Question

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

  • April 23, 2019
  • 2 replies
  • 14 views

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!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

david_r
Celebrity
  • 8394 replies
  • 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
  • Author
  • 21 replies
  • 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).

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