[C#] Column(string) method in RecordBatch is linear to the number of columns

[vthemelis]

Describe the enhancement requested

It looks like a column lookup by name is linear to the number of columns. This is not intuitive and can easily lead to performance regressions. Would it be possible to add a lookup to convert this into an O(1) operation?

Component(s)

C#

[CurtHagenlocher]

Column names are not actually required to be unique, which is why Schema.Fields is marked deprecated. If you know that the column names in your data are unique, you could still use it. Otherwise, we'd need something like a mapping of a string onto what's possibly a list of field positions.

[vthemelis]

Hi @CurtHagenlocher and thanks for you reply! Very interesting that the column names don't need to be unique. I don't mind so much about that. I personally just want the existing retrieval functions to be faster than they are for their most common use-cases.

I added #44633 to do exactly that. Note that I would like to also replace the existing Lookups with signature string -> Field but unfortunately those use StringComparer.Default instead of StringComparer.CurrentCulture. Not sure if this is intentional.