IT Hare on Soft.ware

Disclosure: On this site you won’t find specific advice on “how to call function xyz()”. Interpreting C++ ARM and #pragma dwim is also out of scope.

Read More...

We’re treating our readers as intelligent beings who can use Google and/or StackOverflow, where all such specific questions were answered more than once.

What you will find is opinions, more opinions, and even more opinions on all the aspects of software development - and with a large chunk of them based on real-world experience too.

Your mileage may vary. Batteries not included.

 

Real-World 802.11ac Wi-Fi Testing: 7×6 Routers-x-Adapters Matrix. Part III. Results and Conclusions

posted by

Quote: “There is no such thing as ‘the best router’; strictly speaking – you need to test each specific pair of (router,adapter) to get anywhere-reliable results.”
Another Quote: “with that limited data we have now, I’d rather stay away from Realtek-based adapters.”
[→]

Filed Under: Hardware, Wi-Fi

Real-World 802.11ac Wi-Fi Testing: 7×6 Routers-x-Adapters Matrix. Part I. Routers.

posted by

Quote: “Whatever throughput numbers are promised by router manufacturers, in real world should be divided by the factor of 2.5x-5x”
Another Quote: “Each router was tested with each of the cards/adapters, which gives us 42 tests on 2.4GHz band and 42 tests on 5GHz”
[→]

Filed Under: Hardware, Wi-Fi

OLTP Database Optimization 102 – DIY Heterogeneous Replication (Part II)

posted by

Quote: “The point of Super-Replica is that it is a replica Slave DB which is larger than original Master DB”
Another Quote: “this “don’t write some HISTORICAL data to Master DB” approach can easily allow to reduce the load on the Master OLTP DB by a factor of 2x-3x”
[→]

OLTP Optimization 102: DYI Heterogeneous Replication. Part I (Basics)

posted by

Quote: “there are still several Big Fat Reasons™ to use DIY replicas”
Another Quote: “With the Replication Messages described above, it is ok to apply Replication Messages to Slave DB which is newer than exactly necessary.”
[→]

OLTP DB Optimizations 102 – Group Commits

posted by

Quote: “if we can commit several transactions at the same time – RDBMS needs to fsync() our DB logs to physical disks only once”
Another Quote: “if going our preferred way of single-writing-DB connection – make sure NOT to use RDBMS-level Group Commit”
[→]

OLTP DB Optimizations 102 –100% Coherent App-Level Cache for Single-writing-DB-connection

posted by

Quote: “with our app-level cache, we’re guaranteed to get exactly the same results as if we’d be querying the underlying database.”
Another Quote: “why settle for invalidation when we can modify cache accordingly, saving on the extra DB request when we’re dealing with the same USER again?”
[→]
Copyright © 2014-2016 ITHare.com