#4091 ensure_index takes for ever looping over every single project

v1.1.0
closed
nobody
performance (126) 42cc (432)
General
Dave Brondsema
2015-08-20
2012-04-19
Dave Brondsema
No

EnsureIndexCommand uses for projects in utils.chunked_find(M.Project): to find each project's database_uri because we used to have different db connections for different projects. This is theoretically still supported, but not used. This is terribly slow on a big system though.

We should either remove per-project database_uri functionality, or have some smart logic (perhaps a command option) so EnsureIndexCommand doesn't go through all the projects looking for new databases.

Discussion

  • Dave Brondsema

    Dave Brondsema - 2013-11-06
    • Labels: performance --> performance, 42cc
    • Status: open --> in-progress
     

  • Igor Bondarenko - 2013-12-26
    • status: in-progress --> code-review
     

  • Igor Bondarenko - 2013-12-26

    Closed #489. {allura, forge-classic}:je/42cc_4091

    Removed per project database_uri functionality.

    Also removed scripts/migrate_project_database.py (migrates per project db to main db), since it's meaningless from now.

     

  • Dave Brondsema

    Dave Brondsema - 2014-01-02
    • QA: Dave Brondsema
     

  • Dave Brondsema

    Dave Brondsema - 2014-01-02
    • status: code-review --> closed
    • Milestone: forge-backlog --> forge-jan-10
     

Log in to post a comment.