O'Reilly

MARCH 26, 2024

To me, the analogy breaks down before it begins: firstly, LLMs don’t merely blur, but perform highly non-linear transformations, which means you can’t just squint and get a sense of the original; secondly, for the photocopier, the error is a bug, whereas, for LLMs, all errors are features. joined Flickr.

Artificial Intelligence 109

Artificial Intelligence Social Media Google Internet 109

SQL Performance

MARCH 29, 2022

Forced parameterization wasn’t added until SQL Server 2005, so Microsoft had the opportunity to incorporate some lessons from the simple parameterization experience, and didn’t have to worry much about backward-compatibility issues. SQL Server requires compatible types before performing the division. Without Simple Parameterization.

Cache 90

Cache Servers Database Testing 90

SQL Performance

JULY 1, 2021

These types are on the deprecated list for many reasons, and have held a permanent spot on that list since being replaced by the max types way back in SQL Server 2005. t2 ( id bigint IDENTITY PRIMARY KEY , msg ntext ) ; Now, let's try to perform online operations on the tables: ALTER TABLE dbo. CREATE TABLE dbo. Conclusion.

C++ 58

C++ Database Servers Performance 58

All Things Distributed

SEPTEMBER 20, 2013

Many of the modern high-performance data warehouses such as Amazon Redshift are based on column stores. The first practical modern implementation is probably C-Store by Stonebraker, et al. There is a great tutorial by Harizopoulos, Abadi and Boncz from VLDB 2009 that takes you through the history, trade-off''s and the state of the art.

Storage 90

Storage Hardware Cache C++ 90

SQL Performance

AUGUST 1, 2022

If you’re using T-SQL to compute percentiles as part of your work, these functions should be familiar to you since they’ve been supported in SQL Server 2005 and later. Computing accurate percentiles has negative implications in terms of memory footprint and performance. 75 Test XYZ Student C 55 Test XYZ 77.5

Servers 142

Servers Testing C++ Code 142

SQL Performance

FEBRUARY 22, 2021

The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections. I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us.

Latency 57

Latency Servers Monitoring Systems 57

ScaleOut Software

JUNE 22, 2020

Software platforms for distributed caching, such as ScaleOut StateServer ®, which was introduced in 2005, hide internal mechanisms for cluster membership, throughput scaling, and high availability to take full advantage of the cluster’s scalable memory without adding complexity to applications.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

ScaleOut Software

JUNE 22, 2020

Software platforms for distributed caching, such as ScaleOut StateServer ®, which was introduced in 2005, hide internal mechanisms for cluster membership, throughput scaling, and high availability to take full advantage of the cluster’s scalable memory without adding complexity to applications.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

SQL Performance

SEPTEMBER 29, 2021

There are several methods to reload entire tables while they’re actively being queried; two decades ago, I took unbridled advantage of sp_rename — I’d play a shell game with an empty shadow copy of the table, happily reloading the shadow copy and then only performing the rename inside a transaction. Description / symptoms. Schema Transfer.

Servers 55

Servers Games Database Processing 55

Brendan Gregg

JUNE 3, 2021

It was 2005, and I felt like I was in the eye of a hurricane. I was an independent performance consultant and Sun Microsystems had just released DTrace, a tool that could instrument all software. This gave performance analysts like myself X-ray vision. You can't make this stuff up. DTraceToolkit v0.96

Open Source 40

Open Source Code Engineering Technology 40

SQL Server According to Bob

JUNE 22, 2016

Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. This means that trace flag -T8048 is no longer valid or needed on SQL Server 2016 because the design is such that SQL Server dynamically adjusts to CMemThread wait activities in order to optimize performance.

Servers 40

Servers Azure Software Engineering Design 40

Smashing Magazine

DECEMBER 2, 2021

Good ol’ PerfPlanet is back for another season with all things speed and web performance. Anyone is welcome to contribute to the calendar , so do feel free to reach out with a topic or tool you’re passionate about, or a technique you’d like to teach and tell the web performance community about. Stoyan Stefanov on Twitter.

Design 107

Design Development Programming Website 107

SQL Performance

OCTOBER 9, 2019

As an example, suppose that you need to perform some task per database in your instance. Since the inception of the OUTPUT clause for modification statements in SQL Server 2005, it turned out to be a very practical tool whenever you wanted to return data from modified rows. Open the cursor. Iterate through the cursor records.

C++ 111

C++ Database Servers Code 111

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. In this article, I’ve focussed on service worker caching, but other forms of caching can help performance and CPU usage too! Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

Brendan Gregg

MARCH 16, 2024

I'm sure this delivered large performance improvements and I wouldn't try arguing against it. 2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. But I'd rather the cost be zero, of course!

Java 145

Java Cache Google Hardware 145

The Agile Manager

SEPTEMBER 30, 2013

Technocracy was, too: "best practice" was derived from people performing narrowly defined tasks in rigid processes that yielded poor quality products at a high cost. Frederick Taylor defined and measured performance down to the task level. In the 1980s, it seemed we were on the cusp of a revolution in management.

Education 45

Education Best Practices Retail Network 45

SQL Server According to Bob

JANUARY 11, 2020

As ​​ the ​​ administrator of a SQL Server 2005 installation, ​​ you will find that ​​ visibility into ​​ the ​​ SQL Server ​​ I/O ​​ subsystem ​​ has been ​​ significantly increased.

Servers 40

Servers Cache Database Media 40

Dynatrace

DECEMBER 22, 2021

With observability, teams can understand what part of a system is performing poorly and how to correct the problem. Traces provide performance data about tasks that are performed by invoking a series of services. The key is knowing what is the root cause of the performance issue. Observability platforms provide context.

Artificial Intelligence 185

Artificial Intelligence Metrics Architecture DevOps 185

SQL Performance

FEBRUARY 17, 2022

Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. ( 1 Pink Floyd, New Order, The Hip 2 Zamfir, ABBA. FavoriteBands.

Servers 82

Servers Code Efficiency Performance 82

John McCalpin

APRIL 2, 2020

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). These numbers come from plugging in synthetic performance numbers from a model with variable overlap into the bounds analysis.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

Daniel Lemire

FEBRUARY 8, 2019

In some instances, libdivide can even be more efficient than compilers because it uses an approach introduced by Robison (2005) where we not only use multiplications and shifts, but also an addition to avoid arithmetic overflows. What if d is a constant, but not known to the compiler? Then you can use a library like libdivide.

C++ 279

C++ Benchmarking Hardware Testing 279

SQL Performance

JANUARY 23, 2020

"Waitstats helps us identify performance-related counters. But waits information by itself isn't enough to accurately diagnose performance problems. The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.".

Tuning 115

Tuning Servers Monitoring Hardware 115

Smashing Magazine

JULY 9, 2021

The British Standards Institution (2005) defines inclusive design as : “The design of mainstream products and/or services that are accessible to, and usable by, as many people as reasonably possible. without the need for special adaptation or specialized design.”. Getting on board with accessibility is something we should all do.

Website 145

Website Mobile Design Testing 145

Smashing Magazine

MAY 17, 2021

Performance is a core feature of our company, Instant Domain Search —it’s in the name. I founded Instant Domain Search in 2005 and kept it as a side-hustle while I worked on a Y Combinator company (Snipshot, W06), before working as a software engineer at Facebook. Beau Hartshorne. 2021-05-17T11:30:00+00:00. 2021-05-17T14:40:42+00:00.

Google 93

Google Analytics Serverless Metrics 93

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Server According to Bob

DECEMBER 18, 2018

Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The “forced flush” changes in SQL Server avoid flushes, when possible, in order to improve performance on non-optimized Fua file systems. Performance points of reference: The following charts highlight the increase in performance.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

SEPTEMBER 16, 2021

It looked realistic in 2004 but the rule was already irrelevant by 2005. There are plenty of issues that may really harm your business (poor performance, bad UX design, insufficient SEO, and so on), but in general, they won’t do as much harm as the four I identify below. So we added this constraint to our sanity check.

Automotive 138

Automotive Website Social Media Design 138

KeyCDN

MARCH 28, 2019

Features Simple and fast routing engine Comes with its own CLI Powerful template system (Blade) Good documentation CakePHP CakePHP is one of the first PHP frameworks to be released back in 2005. Check out how to perform an Express CDN integration with KeyCDN. A few examples of large websites using Express include: Uber, Accenture, IBM.

Programming 77

Programming Website Scalability Design 77

SQL Performance

MARCH 30, 2021

It includes initializing each operator, and adding hidden profilers to collect runtime performance data like actual row count and elapsed time. The fundamentals of row mode parallel execution haven’t changed since SQL Server 2005, so the following discussion is broadly applicable. Compatibility level 150 is used exclusively.

Cache 98

Cache Servers Operating System Processing 98

SQL Performance

MARCH 22, 2022

Both target performance and efficiency for workloads frequently submitting simple statements. When SQL Server 2005 introduced Forced Parameterization , the existing auto-parameterization feature was renamed to Simple Parameterization. This is the first part of a series about simple parameterization and trivial plans. Shell Plans.

Cache 61

Cache Servers Database Code 61

SQL Performance

AUGUST 12, 2020

T-SQL supports it starting with SQL Server 2005. Furthermore, it’s important not to confuse the use of table expressions and temporary tables, but that’s a performance related discussion that I will address in a future article. You can find it in the documentation of Microsoft SQL Server and Azure SQL Database. orderyear , CUR.

C++ 140

C++ Code Design Database 140

IO River

NOVEMBER 2, 2023

‍You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. For example, Akamai introduced ASI in 2005, which became the standard for building new websites. And one day, your team lead decides that CloudFront is more costly and to change your CDN provider.‍However,

Lambda 52

Lambda AWS Cache Website 52

SQL Server According to Bob

JUNE 3, 2016

In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations. With our focused investment in performance and scale, simply upgrading to SQL 2016 could bring 25% performance improvement. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 40

Virtualization AWS Hardware Storage 40

IO River

NOVEMBER 2, 2023

You might keep introducing CDN-level features specific to CloudFront that significantly improve your application's performance. Later on, your service might require security, and you might use AWS Web Application Firewall, which directly integrates with Amazon CloudFront to help secure your service.

Lambda 52

Lambda AWS Cache Website 52