Best algorithm for doing fixed-point euclidean difference?

Summary The problem at hand is to find a fast algorithm for computing the fixed-point Euclidean distance in 3D space on a 32-bit RISC-V processor with fast multiply but no arbitrary divide. The current approach involves calculating the distance squared using 16.16 fixed-point math and then performing a square root operation. Root Cause The root … Read more

Why does using an array in EF Core LINQ queries instead of a list cause performance issues in .NET10 / C#14.0?

Summary The recent upgrade to .NET10 from .NET9 has introduced performance issues in existing EF Core LINQ queries. The root cause of this issue is the use of arrays instead of lists in these queries. In this article, we will explore the reasons behind this performance degradation and why switching to lists resolves the issue. … Read more

How to build a xtensa-esp32-elf toolchain that is able to run on Android aarch64-linux-android?

Summary The goal is to build a xtensa-esp32-elf toolchain that can run on Android aarch64-linux-android. The initial attempt using crosstool-ng resulted in a toolchain with libc statically linked, leading to large executables. An alternative approach using the Android NDK for dynamic linking encountered issues with unrecognized command-line options. Root Cause The root cause of the … Read more

Upgradin to .Net 10: System.PlatformNotSupportedException : Microsoft.Data.SqlClient is not supported on this platform

Summary The System.PlatformNotSupportedException is thrown when running tests in Azure after upgrading a .NET 8 project to .NET 10 and updating all NuGet packages. This error occurs despite adding the Microsoft.EntityFrameworkCore.SqlServer NuGet package directly to the project. Root Cause The root cause of this issue is that Microsoft.Data.SqlClient is not supported on the platform being … Read more

How to check LeetCode problem contribution status if no email update received?

Summary The LeetCode problem contribution process can be unclear, especially when it comes to tracking the status of a submitted problem. Key takeaways include understanding the typical communication flow from LeetCode and knowing how to proceed when there’s no update. Root Cause The root cause of the confusion often lies in: Lack of clear communication … Read more

Oracle APEX Interactive Report advice

Summary The problem at hand involves customizing an Oracle APEX Interactive Report to enable single-click download without using the default style. The requirement is to bypass the standard “Action” menu and directly offer a “Download” option, similar to what can be achieved with Interactive Grids (IG) using JavaScript. Root Cause The root cause of this … Read more