Skip to content
FR EN

Handbook of Sustainable Design of Digital Services

MENU
← go back
Backend    ODD#12     ODD#13    

Is the number of requests kept to a minimum (no looping) ?

Recommendation  Essential

Data

C People

A Planet

A Prosperity

Difficulty

*

Priority

High

Récurrence

OnUpdate

Tests

How many queries are used for a given user request?

Precisions

Since each exchange consumes resources on both the sender and the recipient ends, the number of these exchanges should be kept to a minimum.

Use Case

Source code checks cover performance

Opquast 71 / GreenIT 72

Additional elements

Operational issues related to the project

Posts

Rule for assessing the level of compliance of the criterion

Formalized = 100 ; Planned = 75 ; Identified = 50 ; Ignored = 0 / 100

Life cycle

Réalisation

19 other criteria related to the recommendation: Reduce the impact of data from its storage and access

Advice

Data

Are the slow query detection thresholds set effectively ?

Advice

Data processing

Does regulated data (personal, health, financial) comply with the recommendations for structuring these categories of data ?

Recommendation

security

Is sensitive user data secure ?

Recommendation

Data processing

Does the API provide limits, filters and the list of fields to return ?

Recommendation

Data processing

Is the data collected really useful ?

Recommendation

Data processing

Is sensitive data collected ?

Recommendation

Data processing

Does the data have an expiration date when it is deleted ?

Recommendation

Data

Are data replications between multiple Database Engine (Cluster) instances appropriate for sensitivity and availability requirement ?

Recommendation

Data

Is frequently accessed data available in RAM ?

Recommendation

Data

Are "live" and "dead" data handled differently (eg: Slow storage for "dead" data) ?

Advice

Data

Are EXPLAIN clauses used on "Slow queries" to optimize indexes ?

Advice

Data

Have the different data access solutions (queries, triggers, stored procedures) been tested ?

Advice

Data

Is a NoSql solution more efficient than its relational equivalent ?

Advice

Data

Is an alternative to the relational model being considered ?

Recommendation

Data

Are database indexes consistent with operations ?

Recommendation

Data

Is the removal of obsolete data being managed ?

Advice

Data

Can data be backed up incrementally ?

Recommendation

Data

Do implemented queries use joins rather than multiple queries ?

Advice

Data

Is an alternative to SQL queries used when possible (local storage or similar) ?