All Tags
AWS
ai
algorithm-design
architecture
browser
cloud
cloud-efficiency
cloud-principles
cost-reduction
data-centric
data-compression
data-processing
deployment
design
documentation
edge-computing
email-sharing
energy-efficiency
energy-footprint
enterprise-optimization
green-ai
hardware
libraries
llm
locality
machine-learning
maintainability
management
measured
microservices
migration
mobile
model-optimization
model-training
multi-objective
network-traffic
parameter-tuning
performance
queries
rebuilding
scaling
services
storage-optimization
strategies
tabs
template
testing
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
