Sustainability Best Practices
CMSCloudHeartcoreDXP
  • Introduction
  • Infrastructure
    • Infrastructure Overview
    • Hosting
    • Architecture
    • Security and Bots
  • Backend
    • Backend Overview
    • Upgrades and patches
    • Cache responses
    • Sustainable Design Patterns
    • Performance Testing
    • Common pitfalls
    • SOAP, REST and GraphQL
    • SQL optimization
    • JAMstack
    • Monolithic vs. Service based Architecture
    • Async
    • Background tasks
  • Frontend
    • Frontend Overview
    • Page weight budget
    • Image optimization
    • Asset optimization
    • Limit use of 3rd parties
    • Lazyload resources
    • Mobile first
  • Editor
    • Editor Overview
    • Content Types
    • Content Optimization
    • Design Choices
    • Data Management
    • Housekeeping
  • Telemetry
    • Telemetry Overview
    • February 2024
Powered by GitBook
On this page

Was this helpful?

Edit on GitHub
Export as PDF
  1. Backend

SQL optimization

Efficient SQL optimization, particularly in the precise utilization of joins, carries significance within the framework of sustainable system design.

Employing the correct joins can enhance database performance, leading to reduced resource consumption, minimized processing time, and ultimately, a more sustainable system.

By crafting queries that make optimal use of joins, developers can avoid data redundancy, eliminate unnecessary processing, and ensure efficient data retrieval.

This streamlined approach aligns seamlessly with sustainable design principles, where resource efficiency and reduced strain on infrastructure are vital for long-term system viability.

A well-optimized SQL schema with appropriate joins contributes not only to faster response times and enhanced user experiences. But it also minimizes the system's energy requirements. Thus, investing in proper SQL optimization practices, specifically focusing on the judicious use of joins, is a pivotal step.

A pivotal step towards creating a software ecosystem that operates harmoniously with the ideals of environmental preservation and resource efficiency.

PreviousSOAP, REST and GraphQLNextJAMstack

Last updated 1 year ago

Was this helpful?