Recommendation : 1. Reduce the impact of data from its storage and access
Is an alternative to SQL queries used when possible (local storage or similar) ?
Data
B People
B Planet
B Prosperity
Difficulty
N/A
Priority
/
Récurrence
/
Tests
What data could be stored locally?
Precisions
Database management engines provide powerful technical solutions but at the expense of complex and therefore resource-intensive technical mechanisms. Sometimes simpler solutions provide a similar result with less wasted resources.
Additional elements
Rule for assessing the level of compliance of the criterion
0 / 0
Life cycle
Réalisation
19 other criteria related to the recommendation: Reduce the impact of data from its storage and access
Data
Is the number of requests kept to a minimum (no looping) ?
Data
Are the slow query detection thresholds set effectively ?
Data processing
Does regulated data (personal, health, financial) comply with the recommendations for structuring these categories of data ?
security
Is sensitive user data secure ?
Data processing
Does the API provide limits, filters and the list of fields to return ?
Data processing
Is the data collected really useful ?
Data processing
Is sensitive data collected ?
Data processing
Does the data have an expiration date when it is deleted ?
Data
Are data replications between multiple Database Engine (Cluster) instances appropriate for sensitivity and availability requirement ?
Data
Is frequently accessed data available in RAM ?
Data
Are "live" and "dead" data handled differently (eg: Slow storage for "dead" data) ?
Data
Are EXPLAIN clauses used on "Slow queries" to optimize indexes ?
Data
Have the different data access solutions (queries, triggers, stored procedures) been tested ?
Data
Is a NoSql solution more efficient than its relational equivalent ?
Data
Is an alternative to the relational model being considered ?
Data
Are database indexes consistent with operations ?
Data
Is the removal of obsolete data being managed ?
Data
Can data be backed up incrementally ?
Data
Do implemented queries use joins rather than multiple queries ?