Project

General

Profile

Actions
Copy link

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 almost 10 years ago.

Status:
Released
Priority:
2
Assignee:
François ARMAND
Category:
Performance and scalability
Target version:
2.10.0~beta1
Pull Request:
https://github.com/Normation/rudder/p...
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
Copy link
 #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
Copy link
 #2

Updated by Nicolas CHARLES almost 11 years ago

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

Updated by François ARMAND almost 11 years ago

  • Category changed from Architecture - Code maintenance to Performance and scalability
Actions
Copy link
 #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
Copy link
 #5

Updated by Anonymous almost 11 years ago

Actions
Copy link
 #6

Updated by Nicolas CHARLES almost 11 years ago

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

Updated by Vincent MEMBRÉ almost 11 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
Copy link
 #8

Updated by Benoît PECCATTE almost 10 years ago

  • Tracker changed from Enhancement to Architecture
Actions
Copy link

Also available in: Atom PDF