Remove c
article thumbnail

Faster remainders when the divisor is a constant: beating compilers and libdivide

Daniel Lemire

I believe that all optimizing C/C++ compilers know how to pull this trick and it is generally beneficial irrespective of the processor’s architecture. In concrete terms, here is the C code to compute the remainder of the division by some fixed divisor d : uint32_t d =. ; // your divisor > 0. Can we do better?

C++ 279
article thumbnail

Fundamentals of table expressions, Part 5 – CTEs, logical considerations

SQL Performance

T-SQL supports it starting with SQL Server 2005. The issue with this solution is that you cannot assign a name to a table expression and reuse it in the same logical query processing step. In logical query processing terms, by the time you get to the outer query, the CTE name is already defined and available. orderyear , CUR.

C++ 140
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

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

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
article thumbnail

How to Avoid Vendor Lock In

IO River

Therefore, there might be cases where your system could experience a downtime during the migration process. Not only that, but there can be cases where a piece of your application could break during the migration process that could take a long time to get back running.‍How How does vendor lock-in occur?It's

Lambda 52
article thumbnail

Linux Load Averages: Solving the Mystery

Brendan Gregg

This measures demand, which can be greater than what the system is currently processing. 42/3411 43603. . ## History The original load averages show only CPU demand: the number of processes running plus those waiting to run. The load average is an average of the number of runnable processes over a given time period.

Latency 111
article thumbnail

How to Avoid Vendor Lock In

IO River

Therefore, there might be cases where your system could experience a downtime during the migration process. Not only that, but there can be cases where a piece of your application could break during the migration process that could take a long time to get back running.‍How does vendor lock-in occur?It's

Lambda 52
article thumbnail

Data Mining Problems in Retail

Highly Scalable

More specialized data mining applications like supply chain optimization and fraud detection are out of scope, as well as the implementation details of the data mining process (such as evaluation of model quality). Outputs of this tier can be used to configure downstream processes.

Retail 152