Recommendation : 1. Reduce the impact of data from its storage and access
Is the number of requests kept to a minimum (no looping) ?
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
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
Data
Is an alternative to SQL queries used when possible (local storage or similar) ?
Data
Do implemented queries use joins rather than multiple queries ?
Data
Can data be backed up incrementally ?
Data
Is the removal of obsolete data being managed ?
Data
Are database indexes consistent with operations ?
Data
Is an alternative to the relational model being considered ?
Data
Is a NoSql solution more efficient than its relational equivalent ?
Data
Have the different data access solutions (queries, triggers, stored procedures) been tested ?
Data
Are EXPLAIN clauses used on "Slow queries" to optimize indexes ?
Data
Are the slow query detection thresholds set effectively ?
Data
Are "live" and "dead" data handled differently (eg: Slow storage for "dead" data) ?
Data
Is frequently accessed data available in RAM ?
Data
Are data replications between multiple Database Engine (Cluster) instances appropriate for sensitivity and availability requirement ?
Data processing
Does the data have an expiration date when it is deleted ?
Data processing
Is sensitive data collected ?
Data processing
Is the data collected really useful ?
Data processing
Does the API provide limits, filters and the list of fields to return ?
security
Is sensitive user data secure ?
Data processing
Does regulated data (personal, health, financial) comply with the recommendations for structuring these categories of data ?