Mongo Dex Indexes to be Built

(by william, last updated: mar 2013)

{
    "runStats": {
        "linesRecommended": 711108, 
        "linesProcessed": 715011, 
        "linesPassed": 9497091
    }, 
    "results": [

        // parallel arrays 
        {
            "index": "{'status': 1, 'domain_id': 1, 'last_crawled': 1, 'potential_keywords': 1, 'tags': 1}", 
            "queryCount": 42, 
            "namespace": "marketfugraph_production.graph_pages", 
            "totalTimeMillis": 1439641, 
            "avgTimeMillis": 34277
        },

        // already exists (15 second query)
        {
            "index": "{'domain_id': 1, 'status': 1}", 
            "queryCount": 73, 
            "namespace": "marketfugraph_production.graph_pages", 
            "totalTimeMillis": 1142394, 
            "avgTimeMillis": 15649
        }, 

        // cannot index parallel arrays 
        {
            "index": "{'market_rank': 1, 'tags': 1, 'domain_id': 1, 'anchor_words': 1}", 
            "queryCount": 32, 
            "namespace": "marketfugraph_web_production.backlinks", 
            "totalTimeMillis": 16583, 
            "avgTimeMillis": 518
        },

        // already exists (3 second queries)
        {
            "index": "{'domain_id': 1, 'issue_category': 1, 'last_crawled': 1}", 
            "queryCount": 28, 
            "namespace": "marketfugraph_production.graph_pages", 
            "totalTimeMillis": 86210, 
            "avgTimeMillis": 3078
        }, 

        // cannot index parallel arrays 
        {
            "index": "{'project_ids': 1, 'ignore_project_ids': 1}", 
            "queryCount": 12, 
            "namespace": "marketfugraph_web_production.potential_keywords", 
            "totalTimeMillis": 14092, 
            "avgTimeMillis": 1174
        }, 

        // multi arrays
        {
            "index": "{'tag': 1, 'project_ids': 1, 'ignore_project_ids': 1}", 
            "queryCount": 9, 
            "namespace": "marketfugraph_web_production.potential_keywords", 
            "totalTimeMillis": 5068, 
            "avgTimeMillis": 563
        }
    ]
}