All Tags
AWS
algorithm-design
architecture
cloud-principles
cost-reduction
data-centric
data-compression
data-processing
deployment
design
edge-computing
energy-footprint
hardware
libraries
locality
machine-learning
management
measured
migration
model-optimization
model-training
performance
queries
rebuilding
scaling
services
strategies
template
workloads
Tactic: Use efficient queries
Tactic sort:
Awesome Tactic
Type: Software Practice
Category: green-software-practice
Title
Use efficient queries
Description
Complex queries can be performed to increase the responsiveness of the application at the expense of energy efficiency. It can be useful to avoid unnecessary “ORDER BY” or to use indexes.
Participant
Software application developers
Related software artifact
MySQL Server + WIkipedia DB
Context
Green Lab
Software feature
< unknown >
Tactic intent
Using efficient queries
Target quality attribute
Energy-efficiency
Other related quality attributes
< unknown >
Measured impact
Measure the response time during query: -25.1% on energy consumption after applying the practice.
Source
Procaccianti, G., Fernández, H., & Lago, P. (2019). Green Software in Practice: Empirical Validation and Assessment of Best Practices for Writing Energy-Efficient Software. Vrije Universiteit Amsterdam, October 2019.Graphical representation
![]( /AwesomeAndDarkTactics/assets/diagrams/model-use_efficient_queries.png)