Database

80% speed gain via Pre-Aggregated subsets vs MongoDB (which gains on bloat)

by
01a49d89 d065 4a30 9f1b 050edd46696e

80% speed gain via Pre-Aggregated subsets vs MongoDB (which gains on bloat) On PostgreSQL https://medium.com/@kanishks772/we-cut-80-of-our-query-time-by-using-this-little-known-sql-pattern-fadec2bdb592 Compare against MongoDB To precisely compare real-world speed between PostgreSQL pre-aggregation using CTEs vs MongoDB aggregation pipelines — Below is a detailed side-by-side analysis — MongoDB 10% slower with smaller datasets — But MongoDB speed advantage increases with increasing datasets … Read more

Best Practices – Mongo Speed vs Distant WAN

by

Best Practices – Mongo Speed vs Distant WAN Yes — MongoDB replica sets across WANs can significantly impact performance, especially for read and write operations that wait on acknowledgments or are sensitive to replication lag. Here’s how to speed up your MongoDB replica set: Best Practices: 1. Yes, remove distant secondaries if: 2. Use readPreference: … Read more

Benchmarks of Docker vs BareMetal

by

Benchmarks of Docker vs BareMetal Note concern over mounted data volumes for Mongo Here are real-world performance comparison examples of MongoDB running on bare-metal vs Docker, using benchmarks and reports from known tests or developer observations: 1. Percona Benchmarks (2018–2020) Setup: MongoDB 4.x tested using YCSB (Yahoo! Cloud Serving Benchmark) and sysbench on identical hardware. … Read more

NetSuite Internals – The 3 Main Tables Transactions, Items, Entities

by
Netsuite items entities transactions

NetSuite Internals – The 3 Main Tables Transactions, Items, Entities NetSuite Internals: Deep Dive into the Three Core Tables NetSuite’s data structure revolves around three primary categories of tables: These tables do not exist as single physical tables but are logical groupings of multiple interconnected tables. Let’s explore each area in depth. 1️⃣ Entities (Customers, … Read more