Project

General

Profile

Actions

Architecture #4527

closed

Architecture #4428: Avoid useless requests and commits in SQL database

Don't commit on database when no modification are made

Added by Nicolas CHARLES almost 11 years ago. Updated over 9 years ago.

Status:
Released
Priority:
2
Category:
Performance and scalability
Target version:
Effort required:
Name check:
Fix check:
Regression:

Description

For the multi databases support, we had to change the way to use Squeryl (see http://www.rudder-project.org/redmine/issues/2121 )
However, one drawback is that we commit after every query, even when it's not necessary, causing stress on database.

We have to prevent this behaviour

Actions #1

Updated by Nicolas CHARLES almost 11 years ago

  • Status changed from In progress to Pending technical review
  • Pull Request set to https://github.com/Normation/rudder/pull/450
Actions #2

Updated by Nicolas CHARLES almost 11 years ago

  • Assignee changed from Nicolas CHARLES to François ARMAND
Actions #3

Updated by François ARMAND almost 11 years ago

  • Category changed from Architecture - Code maintenance to Performance and scalability
Actions #4

Updated by Nicolas CHARLES almost 11 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100
Actions #5

Updated by Anonymous almost 11 years ago

Actions #6

Updated by Nicolas CHARLES almost 11 years ago

  • Parent task changed from #4525 to #4428
Actions #7

Updated by Vincent MEMBRÉ over 10 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 2.10.0~beta1, which was released today.
Check out:

The release announcement: http://www.rudder-project.org/pipermail/rudder-announce/2014-March/000084.html
The full ChangeLog: http://www.rudder-project.org/foswiki/bin/view/System/Documentation:ChangeLog210
Download information: https://www.rudder-project.org/site/get-rudder/downloads/
Actions #8

Updated by Benoît PECCATTE over 9 years ago

  • Tracker changed from Enhancement to Architecture
Actions

Also available in: Atom PDF