performance

SQLDeveloper’s “mystats.sql” equivalent

It just occurred to me that I haven’t blogged about SQLDeveloper yet, something I really need to change ;) This post covers SQLDeveloper...

ARM Goes for Broke With High-Performance Cortex-X1 CPU Core

ARM announced a pair of new CPU core designs on Tuesday and launched a...

Mature Optimization

This comment on why NetNewsWire is fast brings up one of the famous tropes of computer science: The line between [performance...

Improve Row Count Estimates for Table Variables without Changing Code

You probably have heard that table variables work fine when the table variable...

Tips to Enhance Productivity While Working from Home During Lockdown

Before the novel, Covid-19 outbreak, working from home was seen as a trend...

Test your home network performance

With many people being forced to work from home, there’s increased load on consumer ISPs. You may be asking yourself: how well is my ISP performing with even more traffic? Today we’re announcing the general...

Improving perceived performance with image placeholders, precaching, and disabled navigation…

Improving perceived performance with image placeholders, precaching, and disabled navigation transitionsPerceived performance is how fast an application feels to the user. This article covers three strategies that you...

Office Hours June 2020: Exploring the PL/SQL Profilers

The PL/SQL engine offers two profiler utilities to help identify performance bottlenecks in your application:1. DBMS_PROFILERThat's the name of the package that provides an API to the profiler that computes the time...

How to improve your Magento Performance with a free tool

The pace of life has become much quicker. We move fast. We accomplish much. And we expect website performance to keep up with us. Performance is one of the key factors in many areas of our life therefore, and Magento’s performance is no exception. The speed of a website affects every user experience. From first landing on the site, to searching on the site for the various products and services, to selecting and purchasing contents...

Declarative Query Languages are the Iraq War of Computer Science

It’s Memorial Day weekend in the United States. Some people are staying home, others are observing the holiday quietly and others still are using it as an excuse to party because they have seemed to have forgotten...

How to use DBMS_SCHEDULER to improve performance ?

From an application point of view, the oracle scheduler DBMS_SCHEDULER allows to reach best performance by parallelizing your process. Let’s start with the following PL/SQL code inserting in serial several rows from a...

“The Modern Web”

A couple of interesting articles making the rounds: Tom MacWrite: Second-guessing the modern webRich Harris: In defense of the modern web I like Tom’s assertion that React (which he’s using as a stand-in for JavaScript frameworks in general) has an ideal usage: There is a sweet spot of React: in moderately interactive interfaces. Complex forms that require immediate feedback, UIs that need to move around and react instantly....

Exploring MySQL Binlog Server – Ripple

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. However, as the number of slaves increases, they will have a toll on the master resources because the binary...

Route-Fully-Rendered Detection in Angular

Background One of the main pieces of profiling an app's performance is measuring how long it takes to route from one view to another *(more comments at end). If you can track over time your app's...

Heaps in SQL Server: Part 1 The Basics

The series so far: Heaps in SQL Server: Part 1 The Basics This article is the beginning of a series of articles about Heaps in Microsoft SQL Server. Heaps are rejected by many database developers using Microsoft SQL Server. The concerns about Heaps are even fuelled by Microsoft itself by generally recommending the use of clustered indexes for every table. Globally renowned SQL Server experts also generally advise that tables in...

Hands-On with Columnstore Indexes: Part 1 Architecture

The series so far: Hands-On with Columnstore Indexes: Part 1 Architecture Indexes are the key to efficient performance in any relational database. Few index enhancements have been introduced that can improve query speed and efficiency as dramatically as columnstore indexes. Improvements to this feature have been introduced in each subsequent version of SQL Server and have transformed columnstore indexes into the go-to method of...

SQL Server for Linux Performance Monitoring Improvements

SQL Server for Linux Performance Monitoring Improvements Last year I posted a blog with examples using Performance...

Building FunctionTrace, a graphical Python profiler

Firefox Profiler for performance analysis Harald’s Introduction Firefox Profiler became a cornerstone of Firefox’s performance work in the days of Project Quantum. When you open up an example recording, you first...

Key Insights from the 2020 State of SQL Server Monitoring Report

This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This year, 971 database professionals from around the world responded. Here are some of the key insights from the survey: Estates are growing more than ever Companies who reported over 1,000 SQL Server instances grew 9% year-on-year while those reporting fewer than 100 instances have dropped for a second year....