Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
erp5 erp5
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Labels
    • Labels
  • Merge requests 139
    • Merge requests 139
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Environments
  • Analytics
    • Analytics
    • CI/CD
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Graph
  • Jobs
  • Commits
Collapse sidebar
  • nexedi
  • erp5erp5
  • Merge requests
  • !1334

Merged
Created Jan 14, 2021 by Vincent Pelletier@vpelletierOwner

CMFActivity: Reduce distribution query count

  • Overview 37
  • Commits 2
  • Changes 4

The first commit is to fix an unrelated issue, which was discovered while testing the main change.

The main change groups the lookup of activities which would forbid a group of activities from being validated: instead of checking all dependencies for a single activity (typically, tihs means one query for one, and rarely two, dependency type(s)), this change does one query for any number of activities to be validated, but for a single dependency type. The result is:

  • fewer queries overall
  • a simpler execution plan for each activity, to compensate for the increased number of values a column is tested against

/cc @jm @jerome

Assignee
Assign to
Reviewer
Request review from
None
Milestone
None
Assign milestone
Time tracking
Source branch: cmfactivity_distribution
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7