#query-optimization
#query-optimization

[ follow ]

Netflix Serves 84% of Query Results from Cache with Interval-Aware Caching in Apache Druid

Interval-aware caching reuses time-aligned aggregates for rolling windows, serving about 84% of results from cache and cutting Druid query load by about 33%.

DevOps

fromInfoQ

3 days ago

MySQL 9.7: First Major LTS Since 8.4 Brings Enterprise Features to Community Edition

MySQL 9.7.0 GA launches a new 9.7 LTS series with replication, security, and developer enhancements, expanding Enterprise features into Community Edition.

Software development

fromInfoWorld

7 months ago

Optimizing queries by using observability

Observability provides continuous, detailed visibility into query behavior and resource usage to enable strategic, active query optimization in modern enterprise data environments.

Web frameworks

fromDjangocentral

2 years ago

How to Use Subquery() in Django With Practical Examples

Using Django Subquery enables concise, efficient retrieval of related records by embedding queries for complex filtering instead of manual ID list construction.

E-Commerce

fromInfoQ

9 months ago

Amazon S3 Adds Sort and Z-Order Compaction to Improve Apache Iceberg Query Performance

Amazon S3 now supports sort and z-order compaction for Apache Iceberg tables to improve query performance and reduce costs.

fromHackernoon

10 months ago

How to Write Complex Queries in Apache Spark SQL Using CTE (WITH Clause) | HackerNoon

A Common Table Expression (CTE) is a named, temporary result set defined within a single SQL statement, which helps in improving query readability and maintainability.

Data science

[ Load more ]