Remove articles 10-ways-to-test-your-application-server
article thumbnail

Fixing Errant GTID With Orchestrator: The Easy Way Out

Percona

In this article, we will discuss errant Transaction /GTID and how we can solve them with the Orchestrator tool. This could result from a mistake (the application wrote to a replica instead of writing to the source) or by design (you need additional tables for reports). What problem can errant transactions cause? 3306 0s ok 5.7.41-44-log

C++ 81
article thumbnail

DATE_BUCKET and DATETRUNC Improve Optimization of Time-Based Grouping

SQL Performance

Before SQL Server 2022, there was a workaround that enabled relying on index order, but besides being quite ugly, it had its cost, and the tradeoff wasn’t always acceptable. SQL Server 2022 introduces new ways to apply time-based grouping using the DATE_BUCKET and DATETRUNC functions.

Servers 144
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

Emulating the GROUPS Window Frame Option

SQL Performance

This article is dedicated to such a case—specifically, a standard SQL feature related to window functions called the GROUPS window frame option. This article is dedicated to such a case—specifically, a standard SQL feature related to window functions called the GROUPS window frame option. Sample Data. Orders ; CREATE TABLE dbo.

C++ 112
article thumbnail

From monitoring to software intelligence for Flask applications

Dynatrace

When comparing Django and Flask , developers like to highlight that Django provides an all-inclusive experience for developers: you get an admin panel, database interfaces, ORM, and directory structure for your applications and projects out of the box. Implementing distributed tracing for Flask applications.

article thumbnail

Seamlessly Swapping the API backend of the Netflix Android app

The Netflix TechBlog

We did this migration without slowing down the usual cadence of our releases, and with particular care to avoid any negative effects to the user experience. We went from an essentially serverless model in a monolithic service, to deploying and maintaining a new microservice that hosted our app backend endpoints.

Latency 233
article thumbnail

Measuring Performance With Server Timing

Smashing Magazine

Measuring Performance With Server Timing. Measuring Performance With Server Timing. 2018-10-30T03:40:14+02:00. That might be something as simple as trying to figure out why JavaScript on your page isn’t kicking in soon enough, or why images are taking too long to appear on bad hotel wifi. Drew McLellan.

Servers 87
article thumbnail

Number series generator challenge solutions – Part 3

SQL Performance

This month I’m going to focus on a fascinating technique that can be used to handle our challenge, but that also has interesting applications well beyond it. I’ll do my testing in tempdb, enabling time statistics: SET NOCOUNT ON ; USE tempdb ; SET STATISTICS TIME ON ; Earlier ideas. BatchMe ; GO. CREATE TABLE dbo. BatchMe ON 1 = 0.

C++ 134