Topic

#database-optimization

2 articles found

Analysis temporarily unavailable. Please try again in a moment.

TL;DR Built a PostgreSQL extension that creates UUIDs looking like random v4 but containing hidden timestamps. Result: 50% smaller indexes with perfect privacy protection. Available now on PGXN: pgxn install pg_uuid_v8 You know this pain: UUID v4: Random, secure, but terrible for DB indexing (fragme

#cloud-computing#postgresql#uuid#database-optimization

· 2 days ago· Dev.to

ORM Overkill: How Object Relational Mappers Hinder Cloud Database Efficiency

Why Does Using an ORM Decrease Database Performance? While trying to optimize the shipping module in a production ERP, I noticed that database queries were incredibly slow. At first, I examined the SQL queries and checked the indexes. However, I couldn't get the performance boost I expected. The pro

#cloud-computing#database-optimization#orm#performance-tuning