#database-optimization

[ follow ]
#django
Djangocentral
7 months ago
Django

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. [ more ]
Testdriven
3 months ago
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. [ more ]
Djangocentral
7 months ago
Django

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. [ more ]
Testdriven
3 months ago
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. [ more ]
moredjango
Marcin Wanago Blog - JavaScript, both frontend and backend
1 month ago
JavaScript

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. [ more ]
CodeProject
3 months ago
JavaScript

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. [ more ]
| 09. Query Optimization | Data Modeling Deep Dive
3 months ago
JavaScript

Query Optimization

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