Cache, Database, Design and Download - Technology Performance Pulse

PostgreSQL: Pgpool-II Use Cases and Benefits

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. However, as the size of your database grows, it can become challenging to manage and optimize its performance. This can significantly improve query response times and reduce the load on your database servers.

Cache

Cache Open Source Benchmarking Database

Benchmark (YCSB) numbers for Redis, MongoDB, Couchbase2, Yugabyte and BangDB

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. Load and 2.

Benchmarking

Benchmarking Latency C++ Database

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning

Tuning Database Performance Hardware

AWS serverless services: Exploring your options

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Instead of worrying about infrastructure management functions, such as capacity provisioning and hardware maintenance, teams can focus on application design, deployment, and delivery. Compute services.

Serverless

Serverless AWS Lambda Storage

MongoDB Best Practices: Security, Data Modeling, & Schema Design

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices

Best Practices Design Tuning Database

Application vulnerabilities: Important lessons from the OWASP top 10 about application security risks

Dynatrace

MARCH 22, 2023

For these, it’s important to turn off auto-completing forms, encrypt data both in transit and at rest with up-to-date encryption techniques, and disable caching on data collection forms. Use a safe development life cycle with secure design patterns and components. Apply threat modeling and plausibility checks.

Open Source

Open Source Artificial Intelligence Internet Internet

Five Data-Loading Patterns To Improve Frontend Performance

Smashing Magazine

SEPTEMBER 28, 2022

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. It essentially describes the lifetime of each file you download to load your page from the network. It is important to note how much data the client needs to download. Caching Schemes.

Cache

Cache Performance Servers Social Media

Updated Percona Distributions for MySQL, Percona Distributions for MongoDB: Release Roundup March 27, 2023

Percona

MARCH 27, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download.

Open Source

Open Source Servers Scalability Cache

PostgreSQL Upgrade: Tricks With OID Columns and Extensions

Percona

APRIL 3, 2023

SET WITHOUT OIDS; A list of tables with the problem is in the file: tables_with_oids.txt Failure, exiting postgres@xx.xx.xx.xx:~$ more tables_with_oids.txt In database: abs_test public.craft public.ports In database: postgres public.oid_test We can use the below SQL to find tables with OID, and it also generates the DDL to remove.

C++

C++ Database Cache Storage

MezzFS?—?Mounting object storage in Netflix’s media processing platform

The Netflix TechBlog

MARCH 6, 2019

Video encoding is what MezzFS was originally designed for and remains one of its canonical use cases, so we’ll focus on video encoding to describe the problem that MezzFS solves. Disk Caching? — ? MezzFS can be configured to cache objects on the local disk. Regional caching? —?Netflix What problem are we solving?

Media

Media Storage Processing Cache

MongoDB Database Backup: Best Practices & Expert Tips

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices

Best Practices Database Storage Servers

HammerDB for Managers

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking.

Benchmarking

Benchmarking Open Source C++ Cache

How We Optimized Performance To Serve A Global Audience

Smashing Magazine

AUGUST 3, 2023

These pages serve as a pivotal tool in our digital marketing strategy, not only providing valuable information about our services but also designed to be easily discoverable through search engines. Download Time of HTML This is the time it takes to download the page’s HTML file. SEO is key to our success.

Performance

Performance Cache Traffic Metrics

WaterBear: Building A Free Platform For Impactful Documentaries (Part 2)

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Meet Smashing Workshops on front-end, design & UX , with practical takeaways, live sessions, video recordings and a friendly Q&A. We reduced image download size and number of requests by almost 80% with a lazy loading strategy. image preload options. <head>

Cache

Cache Strategy Best Practices Design

WiredTiger Logging and Checkpoint Mechanism

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. The same data, in the form of pages inside the Wiredtiger cache, are also marked dirty. At every checkpoint interval (Default 60 seconds), MongoDB flushes the modified pages that are marked as dirty in the cache to their respective data files (both collection-*.wt

Hardware

Hardware C++ Storage Cache

How To Use Google CrUX To Analyze And Compare The Performance Of JS Frameworks

Smashing Magazine

MAY 12, 2022

One of the costs that Noam mentions is the increased download size, especially JavaScript bundle sizes, that stem from the use of frameworks and other libraries. In particular, the increase in the amount of downloaded JavaScript can have a direct impact on website performance. I highly recommend checking out these articles.

Google

Google Performance Website Mobile

Unlocking the Secrets of TOAST: How To Optimize Large Column Storage in PostgreSQL for Top Performance and Scalability

Percona

FEBRUARY 1, 2023

PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This process is done automatically and does not significantly impact how the database is used. Thus, you can use less disk space.

Storage

Storage Scalability Strategy Performance

Creating A Magento PWA: Customizing Themes vs. Coding From Scratch

Smashing Magazine

NOVEMBER 2, 2021

PWAs have been around for over five years, yet native applications outnumber them both in the quantity ratio and how many times users download them. Application leaders for digital commerce technologies must plan for PWAs when designing digital commerce experiences”. The Design Gives Ground For Utmost Usability.

Code

Code Cache Retail Mobile

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

Smashing Magazine

JANUARY 6, 2020

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Download The Checklist (PDF, Apple Pages, MS Word). Assets Optimizations. Build Optimizations.

Performance

Performance Cache Network Metrics

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

Smashing Magazine

JANUARY 7, 2019

Performance isn’t just a technical concern: it matters, and when baking it into the workflow, design decisions have to be informed by their performance implications. Download The Checklist (PDF, Apple Pages, MS Word). Lara Hogan’s guide on how to approach designs with a performance budget can provide helpful pointers to designers.

Performance

Performance Cache Metrics Network

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

High Scalability

NOVEMBER 25, 2019

To help our customers manage ongoing data explosion, we have designed many of the core components over the last few years. Edge caching. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. Nginx for disk based caching. Disk based caching. Hybrid Sync.

Architecture

Architecture Cache Azure Storage

Tuning SQL Server Reporting Services

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning

Tuning Servers Database Best Practices

One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database. If your workload and service design affords it, consider filtering your data thinking in retrieving just a few rows.

Best Practices

Best Practices Tuning Database Testing

The Performance Inequality Gap, 2021

Alex Russell

MARCH 6, 2021

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 fastest Androids predictably remain 18-24 months behind, owing to cheapskate choices about cache sizing by Qualcomm, Samsung Semi, and all the rest. The Moto G4 , for example. Is that a lot?

Performance

Performance Network Cache Metrics

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: Bob Dorr, Microsoft SQL Server Escalation Published: December, 2004 SUMMARY: Learn the I/O requirements for Microsoft SQL Server database file operations. Then follow the instructions to either download the BOL or browse online.

Servers

Servers Cache Media Hardware

Headless WordPress: The Ups And Downs Of Creating A Decoupled WordPress

Smashing Magazine

OCTOBER 26, 2018

When it comes down to how WordPress is programmed, one thing is certain: it doesn’t follow the M odel- V iew- C ontroller (MVC) design pattern that many developers are familiar with. Chrome’s load time was 1.25s (TTFB was 1.25s, content was downloaded in 3.96ms). Security concerns. So, What Exactly Is A Decoupled WordPress?

Cache

Cache Website Speed Database

MariaDB vs MySQL: Key Differences and Use Cases

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source

Open Source Servers Storage Scalability

Progress Delayed Is Progress Denied

Alex Russell

APRIL 29, 2021

Apple's policy against browser engine choice adds years of delays beyond the (expected) delay of design iteration, specification authoring, and browser feature development. Enable developers to compress data efficiently without downloading large amounts of code to the browser. They may have shipped in iOS 14.5 Compression Streams.

Media

Media Games Education Engineering

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors 14 System and sample databases 15 Determining the formatted sector size of database 15 What sector sizes does SQL Server support? KB boundary 12 Larger transaction logs 13 Restore and attach 14 Format for 4 ?KB

Servers

Servers Cache Database Media

How Improving Website Performance Can Help Save The Planet

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. In 2013, A List Apart published Sustainable Web Design by James Christie. Sustainable Web Design. These include data transfer (i.e.

Website Performance

Website Performance Website Energy Performance

Improving The Performance Of Wix Websites (Case Study)

Smashing Magazine

NOVEMBER 22, 2021

It’s one thing to identify bottlenecks and implement optimizations for a specific website or a few similar websites, and quite another when dealing with many millions of websites, having such a wide variety of functionality, and an almost total freedom of design. Instead, we have to accommodate all of this variability, mostly on-demand.

Website

Website Performance Google Media

SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption

SQL Server According to Bob

JANUARY 26, 2017

Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. That is to ensure your database is encrypted at the file level.

Servers

Servers Database Azure Cache

Understanding Execution Plan Operator Timings

SQL Performance

MARCH 8, 2021

The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. Total elapsed time is 933ms with 6,673ms of CPU time with a warm cache. Alternate designs. This next example query uses the same database and index as before. A final example.

Servers

Servers Tuning Architecture Processing

Smashing Podcast Episode 44 With Chris Ferdinandi: Is The Web Dead?

Smashing Magazine

NOVEMBER 30, 2021

It’s the reason why I was able to become a developer, but every time someone visits a WordPress site out of the box, it has to make a call to a database, grabs some content, mash it into some templates, generate HTML and ship that back to the browser. I built my career on WordPress. That’s a really cool thing.

Technology

Technology Technology Servers Code

Technology Performance Pulse

PostgreSQL: Pgpool-II Use Cases and Benefits

Benchmark (YCSB) numbers for Redis, MongoDB, Couchbase2, Yugabyte and BangDB

Trending Sources

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

AWS serverless services: Exploring your options

MongoDB Best Practices: Security, Data Modeling, & Schema Design

Application vulnerabilities: Important lessons from the OWASP top 10 about application security risks

Five Data-Loading Patterns To Improve Frontend Performance

Updated Percona Distributions for MySQL, Percona Distributions for MongoDB: Release Roundup March 27, 2023

PostgreSQL Upgrade: Tricks With OID Columns and Extensions

MezzFS?—?Mounting object storage in Netflix’s media processing platform

MongoDB Database Backup: Best Practices & Expert Tips

HammerDB for Managers

How We Optimized Performance To Serve A Global Audience

WaterBear: Building A Free Platform For Impactful Documentaries (Part 2)

WiredTiger Logging and Checkpoint Mechanism

How To Use Google CrUX To Analyze And Compare The Performance Of JS Frameworks

Unlocking the Secrets of TOAST: How To Optimize Large Column Storage in PostgreSQL for Top Performance and Scalability

Creating A Magento PWA: Customizing Themes vs. Coding From Scratch

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

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

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

Tuning SQL Server Reporting Services

One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only

The Performance Inequality Gap, 2021

SQL Server I/O Basics Chapter #1

Headless WordPress: The Ups And Downs Of Creating A Decoupled WordPress

MariaDB vs MySQL: Key Differences and Use Cases

Progress Delayed Is Progress Denied

SQL Server I/O Basics Chapter #2

How Improving Website Performance Can Help Save The Planet

Improving The Performance Of Wix Websites (Case Study)

SQL Server Mysteries: The Case of TDE and Permanent Tempdb Encryption

Understanding Execution Plan Operator Timings

Smashing Podcast Episode 44 With Chris Ferdinandi: Is The Web Dead?

Stay Connected