#database-optimization

[ follow ]

Improving the Efficiency of Goku Time-Series Database at Pinterest

Pinterest's Goku database updates optimize storage and resource usage, resulting in a 37% reduction in stored time series data.

Cost Optimization Techniques for AWS DynamoDB in Orchestration Applications | HackerNoon

Effective schema design in DynamoDB is crucial to optimize cost and performance for applications.
#django

Approximate Counting in Django and Postgres

Django's paginator relies on slow SELECT COUNT(*) query. Approaches include approximating row count and custom paginator for faster loading.

Understanding the 'F' Expression in Django: When and Why to Use It

The 'F' expression in Django QuerySets enhances performance by allowing direct database operations without fetching data into Python.

Approximate Counting in Django and Postgres

Django's paginator relies on slow SELECT COUNT(*) query. Approaches include approximating row count and custom paginator for faster loading.

Understanding the 'F' Expression in Django: When and Why to Use It

The 'F' expression in Django QuerySets enhances performance by allowing direct database operations without fetching data into Python.
moredjango

API with NestJS #163. Full-text search with the Drizzle ORM and PostgreSQL

Full-text search in PostgreSQL enables rapid and relevant document searches with Drizzle ORM and NestJS implementation.

Return Multiple Result Sets or DataSet Using Entity Framework

The article discusses optimizing database calls by minimizing database round trips, utilizing ADO.NET and custom mappers even in applications using Entity Framework.

Query Optimization

Optimizing database queries can greatly improve web application performance and reduce the need for expensive hardware scaling or caching solutions.
[ Load more ]