Implementing Database Pagination with Hibernate Query API
Learn how to implement efficient database pagination using Hibernate's setFirstResult and setMaxResults to prevent memory exhaustion and optimize query performance.
Loading…
ReadMeFeed / Community knowledge
#database-optimization
Real questions. Useful conversations. Find the people who know your stack.
beats
hibernateArchitecting a Reputation System: Decoupling Votes from User Profiles
Learn how to build a scalable reputation system by decoupling high-frequency voting actions from user profile updates using asynchronous events and atomic increments.
stackoverflowBalancing UI and Code: Optimizing Drupal Views for Complex Data
Learn when to stop using the Drupal Views UI and start using hook_views_query_alter to handle complex data logic without sacrificing performance.
phpSolving the N+1 Query Problem in SQLAlchemy: Choosing the Right Eager Load
Stop the N+1 query bottleneck in SQLAlchemy. Learn when to use joinedload, subqueryload, and selectinload to optimize database performance without causing Cartesian products.
python
sqlalchemyOptimizing PostgreSQL Retrieval with B-Tree Index-Only Scans
Learn how to use PostgreSQL B-tree Index-Only Scans and the INCLUDE clause to eliminate heap fetches and accelerate data retrieval and pagination.
Solving the Cartesian Product Problem in Sequelize Eager Loading
Learn how to handle the Cartesian product problem in Sequelize by strategically using 'separate: true' and 'required' to optimize database queries and reduce memory usage.
nodejs
sequelizeStop Guessing Your Index Order: Mastering MySQL Composite Indexes
Stop wasting database resources on unused indexes. Learn how the Leftmost Prefix Rule and column selectivity determine whether your MySQL composite index actually speeds up queries or just slows down your writes.
Reducing Database Load with Memcached Distributed Caching
Learn how to implement Memcached as a distributed caching layer to reduce database load using the cache-aside pattern and consistent hashing.
memcachedChoosing the Right Online DDL Algorithm for MariaDB InnoDB Tables
Learn how to choose between INSTANT, INPLACE, and COPY algorithms in MariaDB to perform schema changes on InnoDB tables without causing application downtime.