locked
List of Lists vs Table RRS feed

  • Question

  • Hi All!

    We can handle table data as list of lists, or as Table.

    Obviously, list of lists is less convenient to deal with. But does it have any advantages except the wide list of Table functions, item access extended syntax, and some service around type table?

    First of all from performance point of view?

    Monday, July 29, 2019 12:15 PM

Answers

  • One thing to keep in mind is that the fundamental operation for fetching data in both lists and tables is enumeration -- and not indexing. In general, if you say "give me index 4" against either a table or a list, the underlying behavior is to open an enumerator, skip 4 items and then return the fifth.

    (Internally, there are lists of known length and values where indexing can be done more directly -- but I don't want to be more specific about that because it's an implementation detail and not a promise. There's no similar shortcut for any tables.)

    Monday, July 29, 2019 4:59 PM