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

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

ValKey is Redis open-sourced

Redis valkey

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 … Read more

Best Practices – Mongo Speed vs Distant WAN

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

Madness? Suspect AppArmor FIRST

280c9a6a a733 4351 867c 68c6e339ca2c

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 … Read more

DMARC DKIM SPF Email anti-spam slow-motion trainwreck

9a1bb833 fd2d 4827 9f58 88f07a63ce72

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 … Read more

Benchmarks of Docker vs BareMetal

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 – Transaction_Line Table

Netsuite transaction line table

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 … Read more

Is Oracle NetSuite a Boat Anchor to sink Small Business?

Netsuite small business boat anchor

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 … Read more

Oracle NetSuite N/cache offers coded per-feature optimization

Netsuite ncache

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 … Read more

Inside NetSuite per user Cache claims meaningful 4x Speed Boost

Netsuite 4x speed boost

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 … Read more