If you're in trouble and cannot find an answer to a question which goes beyond Stack Overflow...

If you have a not-so-usual solution for your problems but need to justify it to your boss...

If you like to think on your own rather than blindly follow "common wisdom" and "profound truth"...

...then 'No Bugs' Hare on Soft.ware might be the right place for you.

Your mileage may vary. Batteries not included

Assorted Rants Tagged ‘Server’, page 2:

OLTP DB Optimizations 101 – Thinking in Terms of Execution Plans

posted August 22, 2017 by "No Bugs" Hare

Quote:	“to realize how our queries are working – we need to start thinking in terms of so-called “execution plans”.”
Another Quote:	“it can be faster to use Table Scan rather than Index-Scan+fetch over such a low-selectivity index”
	[→]

posted July 25, 2017 by "No Bugs" Hare

Quote:	“You DO need access control for your CSRs.”
Another Quote:	“This approach means that we can have our cake (have tree-like structures to express access rights) and eat it too (have very fast SQL for checking access)”
	[→]

posted July 19, 2017 by "No Bugs" Hare

Quote:	“for MOGs, support becomes one of the very important parts of the picture, often on par with Content and Graphics.”
Another Quote:	“the quality of support when using synchronous support methods such as live chat/phone support tends to be significantly worse compared to asynchronous support such as e-mails/tickets”
	[→]

posted July 11, 2017 by "No Bugs" Hare

Quote:	“Make sure that your reports are CSR-driven.”
Another Quote:	“The vast majority of Back-End Tools are intended for NON-programmers and NON-admins.”
	[→]

posted July 4, 2017 by "No Bugs" Hare

Quote:	“We need to monitor EVERYTHING we can afford to monitor.”
Another Quote:	“Monitoring data doesn’t really require ACID transactions.”
	[→]

posted June 27, 2017 by "No Bugs" Hare

Quote:	“it is DB which is usually The Bottleneck™ – it means that we’re saving this enormous amount of load, exactly where it really matters.”
Another Quote:	“as discussed above, the real-world task is always about scaling the whole system, including database; and in this regard Stateless-App-based systems exhibit significant problems.”
	[→]

posted June 20, 2017 by "No Bugs" Hare

Quote:	“Whenever Game Event is interrupted for significant time, as a rule of thumb it is better to roll back the interrupted Game Event rather than trying to restore the exact Game World State in the middle of the Game Event.”
Another Quote:	“Just like Scaling Up, improving performance doesn’t provide infinite scalability. However, it happens that it is all about numbers.”
	[→]