Use column store instead of row store for data table

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Won't Fix
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: WiredTiger
    • None
    • Fully Compatible
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      There is a potential performance win to change the data tables (as opposed to the index or metadata/catalog tables) to use column store format instead of row store (see: http://source.wiredtiger.com/develop/schema.html#schema_format_types).

      This is because each document is stored with an internal integer id and normal access patterns can take advantage of columnar lookup. This would require a great deal of testing to prove out, but we've seen up to 30% perf improvements with some read only workloads.

              Assignee:
              David Hows (Inactive)
              Reporter:
              Daniel Pasette (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              16 Start watching this issue

                Created:
                Updated:
                Resolved: