Project

General

Profile

Actions
Copy link

Architecture #4526

closed

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

Change the validation query for the database

Added by Nicolas CHARLES about 10 years ago. Updated about 9 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

Rudder does the following query to check the connection validity:

SELECT tables.table_name FROM information_schema.tables WHERE lower(table_name) = '';

however, it seems the correct query (and which put less stress on the systems) is 

select 1

as said in http://stackoverflow.com/questions/10684244/dbcp-validationquery-for-different-databases

Actions
Copy link

Also available in: Atom PDF