article thumbnail

SQL Server on IoT Edge and Developer Machines – Smaller Footprint

SQL Server According to Bob

The reduction effort started when we shipped SQL Server 2017 ( [link].) The lock manager has partitions, lock block cache and other structures. Reduce the number of partitions and size of the cache. IO Request Caches. SQLPAL may cache I/O request structures with each thread. SQL Server 2017. Lock Manager.

IoT 61
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Linux open command flag used to bypass file system cache.

Servers 90
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Average Page Load Times for 2020 – Are you faster?

MachMetrics

In 2017, mobile internet usage passed desktop as the majority. It is typically reduced via server-side optimizations, such as enabling caching and database indexes. What is the number of resources I should stay under? How fast is the average time to first byte (server delay)? What impact does the increased use of mobile devices have?

article thumbnail

A Decade of Dynamo: Powering the next wave of high-performance, internet-scale applications

All Things Distributed

The success of our early results with the Dynamo database encouraged us to write Amazon's Dynamo whitepaper and share it at the 2007 ACM Symposium on Operating Systems Principles (SOSP conference), so that others in the industry could benefit. This was the genesis of the Amazon Dynamo database. million requests per second.

Internet 128
article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

This blog post was originally published in November 2017 and was updated in June 2023. It supports multiple operating systems and platforms, making it an ideal choice for various applications. Cross-platform compatibility makes MySQL compatible with various operating systems, including Linux, Windows, macOS, and more.

article thumbnail

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]

Smashing Magazine

The idea is quite straightforward: Push the minimal code needed to get interactive for the initial route to render quickly, then use service worker for caching and pre-caching resources and then lazy-load routes that you need, asynchronously. An application shell is the minimal HTML, CSS, and JavaScript powering a user interface.