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 […]
ValKey is Redis open-sourced Redis company made itself irrelevant Valkey replaces Redis due to a licensing conflict and project governance change that caused Redis to no longer be fully open source. Why the Change Happened In March 2024, Redis Labs (the company behind Redis) changed the license of Redis from the permissive BSD license to […]
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: […]
Madness? Suspect AppArmor FIRST AppArmor has caused silent, hard-to-diagnose issues for many people, and it’s even more frustrating because it’s often enabled by default without any loud warning or clear opt-out. So here’s the full story: who made it, where it came from, and how the hell it became default on systems like Debian and […]
DMARC DKIM SPF Email anti-spam slow-motion trainwreck Recently a client’s long-well-running, important email process was broken, halting reception by their sales team of emailed notifications regardings product inquiries on their website. This was all working well before ~January. Quick fix: website will now send emails marked as being “From:sales@YOUR.net” Longer explanation: Microsoft/Outlook and/or 2cows.com apparently […]
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. […]
NetSuite Internals – Transaction_Line Table Transaction_Line Table in NetSuite: A Complete Guide The Transaction_Line table in NetSuite contains line-level details for all types of transactions. This is a child table of the Transaction table, meaning each record represents an individual line item within a transaction (e.g., sales order, invoice, bill, etc.). 1️⃣ Purpose of Transaction_Line […]
Is Oracle NetSuite a Boat Anchor to sink Small Business? “We literally went from [sub-]second response / redraw times to routinely 5 seconds, sometimes 30 seconds or more, in common functions such as adding an Invoice and displaying a table of Invoices… it is totally ridiculous, ruinous to our productivity. … Several expensive consultants have […]
Oracle NetSuite N/cache offers coded per-feature optimization This appears to be a dev-specific option, not a broad/general thing like HeadInClouds’. Someone could implement this N/cache caching by writing code specific to super-slow forms, features, functions. Might be worthwhile to add onto painfully slow functions. Info, link and blurb below. NetSuite offers the ‘N/cache’ module, which […]
Inside NetSuite per user Cache claims meaningful 4x Speed Boost This appears to be a per-user inside-of-netscape cache. Demo shows 5 seconds dropping to 1 second which would be meaningfully faster. A demo of the Record Speed Optimizer SuiteApp, created by Head in the Cloud Development and AzroNet Business Systems. This SuiteApp improves the loading […]