Tips and Tricks

Programming is a field where tips and tricks are abundant.

IT Hares proudly present their own bag of programming tips and tricks.

Understanding Correlated and Uncorrelated Sub-queries in SQL

August 24, 2017 by “No Bugs” Bunny


Quote:

A correlated sub-query is a type of query, where inner query depends upon the outcome of the outer query in order to perform its execution.

Another Quote:

Correlated sub-queries are slower.

Filed under: On.ProgrammingTips and Tricks

Tagged With: SQLDatabase
Read more

Ultra-fast Serialization of C++ Objects

May 16, 2017 by “No Bugs” Bunny

serialization: per-field vs whole struct

Quote:

in both these cases we can be 100% sure that we’ll be deserializing this state on the executable which is identical to the executable which serialized the state.

Another Quote:

Even when comparing with home-grown code with per-field serialization, our Ultra-Fast Serialization still wins (up to 1.5x-2x)

Filed under: On.ProgrammingTips and TricksOptimizations

Read more

Client: Installer & Auto-Updates

February 28, 2017 by “No Bugs” Bunny

Update of Updater

Quote:

Pretty much whatever-we-do, there will be a certain percentage of players which are trying to run an obsolete version of the Client forever-and-ever

Another Quote:

It is very important to keep updater transaction-oriented.

Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.ProgrammingTips and Tricks

Read more

Determinism: Requirements vs Features

December 26, 2016 by “No Bugs” Bunny

Schroedinger's Cat vs Production Post-Mortem, Low-Latency Fault Tolerance, and Replay-Based Regression Testing

Abstract:

Apparently, in practice there is big difference between cross-platform determinism and same-executable determinism, both in abilities they can provide, and from implementation complexity point of view

Quote:

Cross-platform determinism is the strictest definition of determinism I know; not surprisingly, there are quite a few factors which can break it

Filed under: On.System Architecture(Re)ActorsOn.ProgrammingTips and Tricks

Read more