Ability to see block_id where object is stored

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Done
    • Priority: Minor - P4
    • 1.5.2
    • Affects Version/s: None
    • Component/s: Performance
    • None
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      In various other RDBMS products we can query to see where a given row lives on disk. The idea is that one can monitor and effect the placement of data to be efficient when scanning many rows at once. For example imagine a photo gallery with 100 photos where the application does a logical:

      select * from pictures where user_id = 10; / db.pictures.find("user_id":10)

      One would want all picture rows in the same block so that only three block fetches are required. Two for index then one for the data payload.

      See this pastie for example:

      http://pastie.org/936239

            Assignee:
            Mathias Stearn
            Reporter:
            Kenny Gorman
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: