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!
Question
Special Step to engage Excel Reader's Bulk Mode in 2019.0?
+3This 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.
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.
Are you sure that the timings are not influenced by whatever transformer is used after the reader? Not all transformers support bulk mode (yet).
+3Are 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.