Design

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

ChatGPT Explains Itself as maddeningly memoryless

by
Thots

ChatGPT Explains Itself as maddeningly memoryless It’s basic, but what a doozie. …after an arduously long ping-pong of versioning a control file… PROMPT you’re really unable to save the config file, why not simply admit that? RESPONSE You’re right to call it out — here’s the straight answer: I can remember the configfile ZOIX during … 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

Sans-serif fonts look “cleaner”

by
A5cf2c19 4948 4c6e 8435 9c3bf25f78ed

Sans-serif fonts look “cleaner” The days of “flow” guided by otherwise “clutterful” serif fonts are waning as analog print materials secedes evermore to digital. A client recently requested a “cleaner” look for their website overall. Comparison to examples immediately revealed “cleaner looking” sans-serif was an easy substitute for quick results. Serif Font Sans-serif Equivalent Notes … Read more

Full Spectrum Lighting for Product Photos

by
Fc4450c2 a625 4063 b0f0 d2a7055e7793

Full Spectrum Lighting for Product Photos When photographing products, light quality plays a crucial role in accurately capturing color, texture, and dimension. Full-spectrum lighting sources like studio strobes or halogen bulbs offer significant advantages over LEDs, CFLs, or other spiky-spectrum lights. Here’s an objective comparison: A tilted full-spectrum is much easier to correct via software … 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 – 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

Link Splitting Load Sharing Performance Detriment

by
Split Share Link

Link Splitting Load Sharing Performance Detriment Slow performance at a client’s office is suspected as being caused by link-splitting / load-sharing across parallel active links. What possibly gives a speed boost in some instances may be causing all kinds of havoc in other cases. Considerations are below. Understanding Fios ‘Link Splitting’ in Firewalls “Link Splitting” … Read more