Coding

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

Madness? Suspect AppArmor FIRST

by
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

NetSuite Internals – Index

by

NetSuite Internals – Index Slowly but surely detailing the internals of NetSuite. The 3 Main Tables Transactions, Items, Entities https://wp.brenden.com/netsuite-internals-the-3-main-tables-transactions-items-entities/ Transaction Table https://wp.brenden.com/netsuite-internals-transaction-table/ Transaction_Line Table https://wp.brenden.com/netsuite-internals-transaction_line-table/ Several APIs https://wp.brenden.com/netsuite-internals-several-apis/

NetSuite Internals – Transaction Table

by
Netsuite transaction table

NetSuite Internals – Transaction Table NetSuite Transaction Table: A Detailed Breakdown The NetSuite Transaction table is the core database table where all financial and operational transactions are stored. It contains high-level (header) information about each transaction, while related details (such as line items) are stored in separate linked tables. This table is crucial for accounting, … Read more