Blog – Performance | Architecture & Performance

Performanceen25 Mar 2026

Summation of Floating-Point Numbers in Cython

Adding up a list of floating-point numbers: seems simple. IEEE 754 double-precision floats (float64) carry about 15 to 17 significant decimal digits, and…

#Python#Cython#floating-point

Databaseen4 Oct 2025

PG_FASTBCP Postgres Extension

Moving large volumes of data in and out of a PostgreSQL database has always been a critical challenge for developers, data engineers, and database…

#FastBCP#Performance#export

SQL Serveren6 Nov 2024

Beyond LAST_VALUE IGNORE NULLS: Efficient Alternatives for Handling Missing Data in SQL Server

When working with SQL Server, managing missing data efficiently is crucial, especially in large datasets.

#SQL Server#Performance#SQL

SQL Serveren24 Jun 2023

Semantic Vector Search with SQL Server and the help of KMeans indexing

In the previous article Semantic Vector Search with SQL Server we discuss about the possibility to make semantic search with vectors that comes from…

#SQL Server#semantic search#vector

SQL Serveren19 Jun 2023

SQL Server vector search

Some time ago i read a blog article from a senior Microsoft azure programmer Davide Mauri: The article interest me because the current "semantic search"…

#Performance#SQL Server#SQL

SQL Serveren23 Mar 2023

TPCH SF10 : Query 13 and SQL Server Collations Performance Impact

After benchmarking several cloud databases (Snowflake, BigQuery, SingleStore, Databricks) using TPCH SF10 data, after benchmarking DuckDB and Tableau…

#TPC-H#SQL Server#SQL

SQL Serveren8 Mar 2023

SQL Server Extended Events Dashboard

SQL Server Extended Events is a powerful feature in Microsoft SQL Server that enables database administrators to capture and analyze events that occur…

#database#SQL Server#Performance

Performanceen8 Oct 2022

Cloud Comparator : CPU, RAM, Price of VMs

Cloud-Mercato.com is a mine of information about pricing in the cloud world.

#Performance#cloud#finops

Performanceen19 Sept 2022

Intel Processors Comparator

Intel Processor have several characteristics beyond frequency and number of cores.

#Performance#Hardware

Databaseen20 Jun 2022

Talend Quick Tips : Increase BigQuery Talend timeout in components

In this article I will show you how to change a critical setting in Talend: the timeout.

#Talend#BigQuery#Performance

Performanceen26 Apr 2022

More Heapsort in Cython

This post/notebook is the follow-up to a recent one: Heapsort with Numba and Cython, where we implemented heapsort in Python/Numba and Cython and compared…

#Python#Performance#Benchmark

Databaseen20 Apr 2022

Loading data from PostgreSQL to Pandas with ConnectorX

ConnectorX is a library, written in Rust, that enables fast and memory-efficient data loading from various databases to different dataframes.

#Python#Performance#Benchmark

Databaseen16 Apr 2022

Export data as fast as possible : from HANA to CSV

I want to export from HANA to CSV. As source, a table or a sql query, as target an external client, of course as fast as possible and using a command line…

#hana#database#Performance

Performanceen14 Apr 2022

Heapsort with Numba and Cython

Heapsort is a classical sorting algorithm. We are going into a little bit of theory about the algorithm, but refer to Corman et al.

#Python#Performance#Dev

Data Visualizationen1 Apr 2022

Tableau 2022 Optimize Workbook Feature : first test

"Optimize Workbook" is a new feature of Tableau 2022. .. but infortunatly the link redirect tableau.com root website where we could expect a technical…

#Tableau#Dataviz#Performance

Data Visualizationen28 Mar 2022

Tableau Performance Tips #8 : Avoid using Tableau Groups

Tableau allow users to build their own custom groups very easily. This is a convenient way to regroup data on elements that users want to see regrouped.

#Tableau#Dataviz#Performance

SQL Serveren25 Mar 2022

SQL Server Trace Flags Classification

_Trace flags are used to set specific server characteristics or to alter a particular behavior.

#database#Performance#SQL Server

Data Visualizationen23 Mar 2022

Tableau Performance Tips #7 : Prefer to use a one row datasource to display static metadata informations

Tableau does not have really customisable buttons. I mean you can put image on your dashboard but you cannot display the text you want with the formatting…

#Dataviz#Tableau#Performance

Data Visualizationen20 Mar 2022

Tableau Performance Tips #6 : Avoid using NOW() for filtering or selecting against a fact datasource

Some databases implement a result cache (or query cache depending the name), it is a cache for the results of some queries.

#Dataviz#Tableau#Performance

Data Visualizationen17 Mar 2022

Tableau Performance Tips #5 : Sort only with element(s) in the view

A performance issue that is not well known is that Tableau sorts is not done by the datasource but by tableau itself.

#Dataviz#Tableau#Performance

SQL Serverfr16 Mar 2022

Compression des données XML dans SQL Server

On stocke des données XML dans une table qui commence à grossir sérieusement et il devient important de réfléchir à des solutions pour essayer de gagner…

#SQL Server#database#Performance

Data Visualizationen14 Mar 2022

Tableau Performance Tip #4 : Avoid using a big datasource to display semi-constant informations

More than often you will want to display semi-constant information like the current timestamp, the Tableau Username, a chosen currency or a simple single…

#Dataviz#Tableau#Performance

Data Visualizationen11 Mar 2022

Tableau Performance Tips #3 : Avoid small list of values to be in the context

Let's begin with a definition of what a list of values is. A list of values is linked to a filter. The filter can be in the context or not. Hum...

#Dataviz#Tableau#Performance

Data Visualizationen8 Mar 2022

Tableau Performance Tips #2 : Avoid total and sub-totals when using a count distinct metric aggregate

If you use a total (or worse) sub-totals when you have metric(s) that is count distinct, this will lead to a second (or several) sequential pass for each…

#Dataviz#Tableau#Performance

Performanceen3 Mar 2022

Applying a row-wise function to a Pandas dataframe

More than 3 years ago, we posted a comparative study about Looping over Pandas data using a CPU.

#Datascience#Python#Performance

Data Visualizationen26 Feb 2022

Tableau Performance Tips #1 : Tableau Performance Recording

Introduction to Tableau Performance RecordingIn this article we will discover how to diagnose your performances with the Tableau performance recording.

#Dataviz#Tableau#Performance

Performanceen15 Feb 2022

A Parallel loop in Python with Joblib.Parallel

The goal of this post is to perform an embarrassingly parallel loop in Python, with the same code running on different platforms [Linux and Windows].

#Python#Performance

Data Visualizationen4 Dec 2021

Tableau Server performance impacted by version history depth of datasources and workbooks

After several tests on real word tableau production environment (+1000 workbooks, +100 shared datasource) we discover that object version history have an…

#Dataviz#Performance#Tableau

Performanceen16 Feb 2021

Optuna and XGBoost on a tabular dataset

The purpose of this Python notebook is to give a simple example of hyperparameter optimization [HPO] using Optuna and XGBoost.

#Datascience#Python#Performance

SQL Serverfr9 Feb 2021

SQL Server CLR Functions vs SQL 2019 Function Inlining

Ce tutorial montre toutes les étapes pour: Découvrez également la nouvelle fonctionnalité SQL Server 2019: le "function inlining" et comment l'activer.

#SQL#Performance#SQL Server

Performanceen30 Dec 2020

Merge Sort with Cython and Numba

In this post, we present an implementation of the classic merge sort algorithm in Python on NumPy arrays, and make it run reasonably "fast" using Cython…

#Performance#Python#Sorting

Performanceen4 Apr 2020

Cython and Numba applied to a simple algorithm: Insertion sort

The aim of this notebook is to show a basic example of Cython and Numba, applied to a simple algorithm: Insertion sort.

#Performance#Python#Sorting

Performanceen30 Jul 2019

Loading data into a Pandas DataFrame - a performance study

Because doing machine learning implies trying many options and algorithms with different parameters, from data cleaning to model validation, the Python…

#Datascience#Performance#Python

Performanceen12 Jun 2019

GPU Analytics Ep 3, Apply a function to the rows of a dataframe

The goal of this post is to compare the execution time between Pandas (CPU) and RAPIDS (GPU) dataframes, when applying a simple mathematical function to…

#Performance#GPU#Python

Databaseen6 May 2019

GPU Analytics Ep 2, Load some data from OmniSci into a GPU dataframe

Although the post title is about loading some data from a GPU database into a GPU dataframe, most of it is about running JupyterLab on a GPU AWS instance…

#SQL#Performance#GPU

Databaseen24 Apr 2019

GPU Analytics Ep 1, GPU installation of OmniSci on AWS

In this post, we are going to install the OmniSci 4.6 GPU database on an Ubuntu 18.04 AWS instance.

#GPU#SQL#Performance

Performanceen3 Jul 2018

Looping over Pandas data

I recently stumbled on this interesting post on RealPython (excellent website by the way!): Fast, Flexible, Easy and Intuitive: How to Speed Up Your…

#Performance#Python#Pandas

#Performance

All articles

Summation of Floating-Point Numbers in Cython

PG_FASTBCP Postgres Extension

Beyond LAST_VALUE IGNORE NULLS: Efficient Alternatives for Handling Missing Data in SQL Server

Semantic Vector Search with SQL Server and the help of KMeans indexing

SQL Server vector search

TPCH SF10 : Query 13 and SQL Server Collations Performance Impact

SQL Server Extended Events Dashboard

Cloud Comparator : CPU, RAM, Price of VMs

Intel Processors Comparator

Talend Quick Tips : Increase BigQuery Talend timeout in components

More Heapsort in Cython

Loading data from PostgreSQL to Pandas with ConnectorX

Export data as fast as possible : from HANA to CSV

Heapsort with Numba and Cython

Tableau 2022 Optimize Workbook Feature : first test

Tableau Performance Tips #8 : Avoid using Tableau Groups

SQL Server Trace Flags Classification

Tableau Performance Tips #7 : Prefer to use a one row datasource to display static metadata informations

Tableau Performance Tips #6 : Avoid using NOW() for filtering or selecting against a fact datasource

Tableau Performance Tips #5 : Sort only with element(s) in the view

Compression des données XML dans SQL Server

Tableau Performance Tip #4 : Avoid using a big datasource to display semi-constant informations

Tableau Performance Tips #3 : Avoid small list of values to be in the context

Tableau Performance Tips #2 : Avoid total and sub-totals when using a count distinct metric aggregate

Applying a row-wise function to a Pandas dataframe

Tableau Performance Tips #1 : Tableau Performance Recording

A Parallel loop in Python with Joblib.Parallel

Tableau Server performance impacted by version history depth of datasources and workbooks

Optuna and XGBoost on a tabular dataset

SQL Server CLR Functions vs SQL 2019 Function Inlining

Merge Sort with Cython and Numba

Cython and Numba applied to a simple algorithm: Insertion sort

Loading data into a Pandas DataFrame - a performance study

GPU Analytics Ep 3, Apply a function to the rows of a dataframe

GPU Analytics Ep 2, Load some data from OmniSci into a GPU dataframe

GPU Analytics Ep 1, GPU installation of OmniSci on AWS

Looping over Pandas data

Need expertise on your project?