Project

General

Profile

Actions

Architecture #4528

closed

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

Change the query made to check the database status in the system Technique

Added by Nicolas CHARLES about 10 years ago. Updated about 9 years ago.

Status:
Released
Priority:
2
Category:
System techniques
Target version:
Effort required:
Name check:
Fix check:
Regression:

Description

In the techniques, we check that the database is alive by performing the following query

select id from ruddersysevents limit 0;

and if it fails, we restart it.

we could simply do the following query, with th same success

select 1;

Actions

Also available in: Atom PDF