Percona

MARCH 30, 2023

Further, open source databases can be modified in infinite ways, enabling institutions to meet their specific needs for data storage, retrieval, and processing. Non-relational databases: Instead of tables, non-relational (NoSQL) databases use document-based data storage, column-oriented storage, and graph databases.

Open Source 77

Open Source Database Storage Scalability 77

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. Each partition holds data that falls within a specific range, optimizing data handling and query speed. So, What is MySQL Partitioning?

Strategy 40

Strategy Storage Database Best Practices 40

Alex Russell

MARCH 6, 2021

TL;DR: A lot has changed since 2017 when we last estimated a global baseline resource per-page resource budget of 130-170KiB. A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. The Moto G4 , for example. Here begins our 2021 adventure. Hard Reset.

Performance 124

Performance Network Cache Metrics 124

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Depending on the database size and on disk speed, a backup/restore process might take hours or even days! Depending on the database size and on disk speed, a backup/restore process might take hours or even days!

Best Practices 74

Best Practices Traffic Database Servers 74

SQL Performance

SEPTEMBER 5, 2019

This table uses columnstore for its primary storage to produce batch mode execution later on. You can skip the WHERE clauses if you are running SQL Server 2017. OPTION ( MAXDOP 1 ) ; This time, only the COUNT_BIG aggregate achieves aggregate pushdown (SQL Server 2017 only). Batch mode execution is all about speed.

Performance 81

Performance C++ Storage Servers 81

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. This processor has a base clock speed of 2.0GHz, with an all-core boost speed of 2.55GHz, and a max boost clock speed of 3.0GHz. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

AUGUST 27, 2019

TPC-H Benchmark Results with SQL Server 2017. HPE has already submitted a new official TPC-H result on SQL Server 2017 for a single-socket, HPE Proliant DL325 Gen10 1U server that was 743,750 QphH@1000GB. TPC-E Benchmark Results with SQL Server 2017. Higher memory speed and bandwidth. Higher memory density/capacity.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Tim Kadlec

JANUARY 9, 2019

I recently profiled a page on a Pixel 2 (released in 2017), and an Alcatel 1x (released in 2018). Mbps download speed Jake Archibald mentioned his relative getting or the 0.8 Mbps download speed my in-laws get at their house. Ballooning bandwidth and storage have fostered complacency that we can do without.

Performance 111

Performance Energy Internet Internet 111

Enprowess

JANUARY 12, 2022

Web development is evolving at a rapid speed with each passing year. And so, it optimizes the page loading speed and reduces the bounce rate. So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Twitter Lite PWA : It was integrated as the standard User Interface in 2017.

Blockchain 59

Blockchain IoT Development Serverless 59

SQL Performance

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

FEBRUARY 3, 2020

Applying page or row compression (both online/offline) to the source before the affinitized copy (offline), to see if compressing the data first could speed up the destination. The downside to the latter is that, in SQL Server 2017, you cannot run this online… but you will be able to in 2019.

Speed 113

Speed Processing Servers Storage 113

The Morning Paper

JANUARY 19, 2020

STELLA: report from the SNAFU-catchers workshop on coping with complexity , Woods 2017, Coping with Complexity workshop. Today’s choice is a report from a 2017 workshop convened with that title, and recommended to me by John Allspaw – thank you John! Take a trivial example with three components A, B, and C.

C++ 50

C++ Systems Software Software 50

Tasktop

JUNE 25, 2020

When I joined Tasktop back in October of 2017, Tasktop was doing really well. Flow Fabric feeds a schemaless immutable storage of digital artifacts, across disciplines and functions. In the grand tradition of our sages, I’ve been contemplating existential questions about Tasktop and wrote a Bar Mitzvah speech of my own. . And it has.

Metrics 52

Metrics Education Innovation Software 52

Alex Russell

OCTOBER 22, 2017

— Alex Russell (@slightlylate) October 4, 2017. JavaScript is the single most expensive part of any page in ways that are a function of both network capacity and device speed. Thankfully, this is somewhat easier than network speeds: more than half of American mobile users are on Android devices. Global Ground-Truth.

Performance 68

Performance Benchmarking Network Mobile 68

Smashing Magazine

JANUARY 7, 2019

You need a business stakeholder buy-in, and to get it, you need to establish a case study on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Note : If you use Page Speed Insights (no, it isn’t deprecated), you can get CrUX performance data for specific pages instead of just the aggregates.

Performance 103

Performance Cache Metrics Network 103

SQL Server According to Bob

DECEMBER 31, 2018

Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. Large traces can encounter the 32-bit SSMS memory limitations. The XEProfiler Sample. Creates an empty DataGrid control. Sorts the EventLocators.

Efficiency 40

Efficiency Code Servers Cache 40

All Things Distributed

DECEMBER 12, 2018

In April 2017, Amazon Web Services announced that it would launch a new AWS infrastructure region Region in Sweden. We are excited to offer a comprehensive portfolio of services, from foundational technologies such as compute, storage, and networking to more advanced services such as containers and serverless computing.

AWS 124

AWS Cloud Games Serverless 124

All Things Distributed

OCTOBER 2, 2017

In support of Amazon Prime Day 2017, the biggest day in Amazon retail history, DynamoDB served over 12.9 In addition, DynamoDB Accelerator (DAX) a fully managed, highly available, in-memory cache further speeds up DynamoDB response times from milliseconds to microseconds and can continue to do so at millions of requests per second.

Internet 128

Internet Internet AWS Performance 128