Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-43977

Fully Indexed Collection

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Investigating
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      We are creation a large collection with 2 fields and both are fully indexed.

       

      For example :

      db.collection.insert ( { x : "sddsqq" })

      db.collection.createIndex ( { x : 1, _id : 1 })

       

      Obviously the index is required for fast random access.  Now the only problem is that the index could end up being larger than the document in terms of storage.  More over 2x the storage is required to store the same 'data' (doc and index entries).

       

      Does Mongo have any plans to make improvement similar to IOT tables in Oracle ?

       

      Thanks

       

      Alex Leong

       

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: