Read() format="ArrayOfArrays/ArrayOfStructs"

[Daemach]

I like the speed of the readLargeFile() method, and returning a Java array of arrays is a workable format. It would be great to add this as an alternative format for spreadsheet.read(), as well as the array type that Lucee produces, which is an array of structs. These are much more efficient to process because of parallelization, and I need to produce an array of structs to insert/upsert using QB (https://qb.ortusbooks.com/), which I use extensively.

[cfsimplicity]

I think you're talking about readCsv() rather than readLargeFile().

I have thought about back-porting some of the benefits of readCsv() to read() but it's not straightforward I'm afraid because there are features that rely on query processing, plus some cross-engine issues.

Definitely on my wish list though if I can work it out.