Percona

APRIL 24, 2023

I keep seeing many articles and talks on “tuning” discussing how creating new indexes speeds up SQL but rarely ones discussing removing them. The more indexes, the more the requirement of memory for effective caching. Cache requirements for indexes are generally much higher than associated tables. What should we do?

Tuning 125

Tuning Cache Storage Database 125

Dynatrace

OCTOBER 21, 2020

One of them being a small cache that would have brought the initial startup time down by about 95%. It shows how Dynatrace makes life so much easier for performance engineers and developers that need to ensure our code is highly optimized for speed and resource consumption. Step 4: Fixing the issue.

Code 242

Code Cloud Engineering Java 242

KeyCDN

FEBRUARY 14, 2019

Let’s cover some ways to speed up GIF animations on your website and look at some alternative formats that you should consider. Why Speed Up GIF Animations? Speed Up GIF Animations With Compression Tools Due to their nature, it’s not possible to make changes to GIF files without affecting their graphical data.

Speed 50

Speed Website Latency Cache 50

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. You can create your own on Chrome UX Dashboard. Large preview ). Large preview ).

Performance 145

Performance Cache Media Metrics 145

CSS - Tricks

APRIL 1, 2021

Speed is also something Google considers when ranking your website placement on mobile. With all of this in mind, I thought improving the speed of my own version of a slow site would be a fun exercise. Compressing, minifying and caching assets. On the flip side, Firefox made their webpages load 2.2 Text-based assets.

Cache 92

Cache Social Media Media Website 92

Percona

JANUARY 9, 2023

NOTE : All tests were applied for MySQL version 8.0.30, and in the background, I ran every query three to five times to make sure that all of them were fully cached in the buffer pool (for InnoDB) or by the filesystem (for MyISAM). But why we can’t just cache the actual number of the rows? sec) What flash speed we saw there!

Cache 75

Cache Engineering Storage Speed 75

Smashing Magazine

AUGUST 9, 2022

PageSpeed Compare is a page speed evaluation and benchmarking tool. It also lists cached resources and identifies unused Javascript. Treo Site Speed also performs site speed audits using data from the Chrome UX Report, Lighthouse and PageSpeed Insights. WebPageTest is, of course, a performance testing suite on its own.

Performance 130

Performance Benchmarking Website Metrics 130

The Morning Paper

FEBRUARY 6, 2020

Last week we looked at a function shipping solution to the problem; Cloudburst uses the more common data shipping to bring data to caches next to function runtimes (though you could also make a case that the scheduling algorithm placing function execution in locations where the data is cached a flavour of function-shipping too).

Serverless 98

Serverless Lambda Cache Latency 98

MachMetrics

DECEMBER 20, 2018

Did you order a 5 course meal, but then only eat 2 of them? Of course not, that would be a waste. Most browsers implement the Intersection Observer API, common libraries make it super simple to implement, and speed is more important than ever. Think about the last time you went out to dinner. Well isn’t that beautiful?!

Cache 75

Cache Speed Internet Internet 75

Percona

MARCH 23, 2023

These guidelines work well for a wide range of applications, though the optimal settings, of course, depend on the workload. By caching hot datasets, indexes, and ongoing changes, InnoDB can provide faster response times and utilize disk IO in a much more optimal way. have been released since then with some major changes.

Performance 125

Performance Hardware Tuning Storage 125

Smashing Magazine

JUNE 2, 2021

Every front-end developer is chasing the same holy grail of performance: green scores in Google Page Speed. Real-life performance for your users and how the website “feels” when you’re using it should not be discounted, even if it costs you a point or two in Page Speed (otherwise, we would all just have a search bar and unstyled text).

Performance 117

Performance Cache Website Mobile 117

Smashing Magazine

JUNE 8, 2021

Image optimization , loading behavior and rendering in the browser require understanding of image formats and image compression techniques, image decoding and browser rendering, image CDNs and adaptive media loading, not to mention effective caching and preloading. DRM-free, of course. DRM-free, of course. DRM-free, of course.

Media 107

Media Cache Google Best Practices 107

Percona

MAY 1, 2023

PostgreSQL performance optimization aims to improve the efficiency of a PostgreSQL database system by adjusting configurations and implementing best practices to identify and resolve bottlenecks, improve query speed, and maximize database throughput and responsiveness. That said, you obviously do not want to reserve all RAM for PostgreSQL.

Tuning 52

Tuning Efficiency Database Performance 52

High Scalability

JULY 20, 2018

That means multiple data indirections mean multiple cache misses. Mark LaPedus : MRAM, a next-generation memory type, is being touted as a replacement for embedded flash and cache applications. Cliff Click : The JVM is very good at eliminating the cost of code abstraction, but not the cost of data abstraction.

Internet 121

Internet Internet Scalability Automotive 121

Smashing Magazine

SEPTEMBER 9, 2021

The solution used in Scrapbook was to use the SWR library of React hooks to update the cached page from the server with client side data fetching. The client is first served the cached statically generated page (generated with getStaticProps() ), in the background the server also begins the process of revalidating that page (read more here ).

Cache 104

Cache Internet Internet Servers 104

Smashing Magazine

APRIL 28, 2021

Image optimization , loading behavior and rendering in the browser require understanding of image formats and image compression techniques, image decoding and browser rendering, image CDNs and adaptive media loading, not to mention effective caching and preloading. DRM-free, of course. DRM-free, of course. DRM-free, of course.

Media 93

Media Cache Google Best Practices 93

Smashing Magazine

JANUARY 6, 2020

You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Start Render time, Speed Index ). Treo Sites provides competitive analysis based on real-world data.

Performance 145

Performance Cache Network Metrics 145

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 104

Performance Cache Metrics Network 104

MachMetrics

NOVEMBER 22, 2020

“Well of course these sites load quickly, there’s nothing there!” However, you can follow all of the tips above to ensure that your images have a minimal impact on your site speed. Outside of the simplicity of each of these sites, they’re not doing anything else radical to ensure site speed.

Website 57

Website Speed Google Cache 57

Speed Curve

JUNE 14, 2021

To overcome some of these challenges, we built our own Java-based player, complete with caching, content compression, and even bandwidth detection so it could switch between video, audio, and text versions of a course depending on network speed. And, of course, what can actually be done to make a site faster?

Retail 52

Retail Internet Internet Education 52

Smashing Magazine

NOVEMBER 17, 2022

Web performance refers to the speed at which a website loads, how fast it’s downloaded, and how an app is displayed on the user’s browser. Clearly, we want to give freedom to our content creators, but we can leave to chance neither the resolution nor the speed of delivery and download of the images that will be displayed on our website.

Media 107

Media Cache Website Mobile 107

MachMetrics

JULY 31, 2020

Most page speed audit tools will send you an error letting you know if your site is not being compressed, however, we really like this tool from Varvy , as it shows you just how much page weight is being saved through compression. Many caching plugins like WPRocket also offer Gzip compression right out of the box.

Speed 67

Speed Servers Google Tuning 67

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. Not as much as we'd like, of course, but the worldwide baseline has changed enormously. There are differences, of course, but not where it counts. The Moto G4 , for example. How bad is it?

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

OCTOBER 26, 2018

In addition to MVC separation, we can (for security reasons or speed improvements) place the JS App on a separate server like in the schema below: Decoupled WordPress diagram. Of course, this is where good planning is crucial. Large preview ). Advantages Of Using The Decoupled Approach. Creating A Simple Decoupled Pages Endpoint.

Cache 79

Cache Website Speed Database 79

KeyCDN

SEPTEMBER 12, 2019

When it comes to marketing your website, there are a lot of different aspects to consider, such as speed, SEO, conversation rates, bounce rate, and many others. The file size of your images of course is very important, but SEO and social media also play an important part in helping your website perform and convert better.

Social Media 106

Social Media Media Google Website 106

The Morning Paper

FEBRUARY 20, 2020

At some later point a SQL query is issued which SELECT s a model and then uses the PREDICT function to generate a prediction from the model given some input data (which is itself of course the result of a query). There are limitations to this model of course. It can’t handle loops for example (an analysis of 4.6M The last word.

Processing 72

Processing Hardware Database Azure 72

SQL Performance

APRIL 8, 2019

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. Of course, if I were buying an AMD-based server for on-premises SQL Server use right now, I would try to get the newer, frequency-optimized AMD EPYC 7371 processor.

Azure 42

Azure Virtualization Storage Benchmarking 42

The Morning Paper

JANUARY 23, 2020

There’s much more colour around these in the full thesis report of course). In fields such as software operations, it can be too easy to assume that the success of business-critical systems are owed solely to the speed, algorithmic prowess, and preventative design of automation. " – wikipedia. The last word.

Internet 53

Internet Internet Cache Engineering 53

Percona

JULY 17, 2023

It’s a good setup for real-time analytics and high-speed logging. Alternatives to MongoDB Enterprise There are plenty of alternatives, but we’re not going to cover them all here, of course. DBAs and developers appreciate its combination of flexibility, scalability, and performance. Couchbase — No.

Open Source 75

Open Source Database Scalability Software 75

Smashing Magazine

JANUARY 21, 2021

Plus a service worker that caches all static assets and serves them for repeat views, along with cached versions of articles that a reader has already visited. We chose to focus specifically on slow mobile devices — with slow 3G, 400ms RTT and 400kbps transfer speed, just to be on the pessimistic side of things.

Performance 145

Performance Cache Mobile Network 145

Sutter's Mill

FEBRUARY 13, 2017

Today, this makes concurrency more important than ever, because it delivers two things: It hides latencies we have to deal with and cannot remove, from disk I/O latency to speed-of-light network latency; and it makes our code responsive by not introducing needless latencies of our own even when we’re not hiding someone else’s latency.

Latency 50

Latency C++ Hardware Performance 50

IO River

NOVEMBER 2, 2023

Real-time monitoring can help detect any anomalies as soon as they happen, thereby increasing the speed at which problems can be diagnosed and solved. ‍Businesses can adjust configurations to manage everything from basic distribution settings to intricate geo-targeted content caching and delivery strategies, all with the same ease.‍‍2.

Open Source 52

Open Source DevOps AWS Azure 52

Speed Curve

FEBRUARY 25, 2024

Individual pages can be spot checked via the CrUX API or tools such as Page Speed Insights But as Cliff's already covered in How to find (and fix!) Guest profiles also start with empty caches, empty cookie stores, empty browser storage, etc.

Analytics 91

Analytics Processing Google Mobile 91

IO River

NOVEMBER 2, 2023

Real-time monitoring can help detect any anomalies as soon as they happen, thereby increasing the speed at which problems can be diagnosed and solved. ‍It Businesses can adjust configurations to manage everything from basic distribution settings to intricate geo-targeted content caching and delivery strategies, all with the same ease.‍‍2.

Open Source 40

Open Source DevOps AWS Azure 40

Smashing Magazine

OCTOBER 22, 2019

At the intersection of the two is website speed. It should come as no surprise that images cause a lot of the problems websites have with speed. Of course, there are the SEO benefits of images, too. That or we’re going to have to get really good at optimizing for speed. Images are a powerful force on the web. Add a CDN.

Mobile 63

Mobile Media Website Storage 63

Smashing Magazine

APRIL 9, 2019

They’d take the hit for the first site to use the file, but then it would sit in their local browser cache and downloads could be skipped for each subsequent site. Another interesting thing you can do is use a Content Security Policy to specify that any script (or styles) on your page must use SRI, and of course that SRI must validate.

Website 58

Website Servers Code Best Practices 58

Alex Russell

OCTOBER 22, 2017

JavaScript is the single most expensive part of any page in ways that are a function of both network capacity and device speed. Add onto that the yawning chasm between low-end and high-end device performance thanks to chip design factors like cache sizes, and it can be difficult to know where to set a device baseline.

Performance 68

Performance Benchmarking Network Mobile 68