optimization

Code optimization techniques for better performance

Programming Why sorted arrays run faster: branch prediction, cache

Why processing a sorted array is faster: fewer branch mispredictions, improved vectorization and cache locality. C++/Java benchmarks and fixes. Practical fixes.

#branch-prediction
#performance
#optimization
#cpp
#java

1 answer• 6 views

01/01/2026, 07:39 PM

Databases PolarDB IMCI: Optimize SELECT * on Wide Tables

Mitigate read amplification for SELECT * on wide tables (500+ columns) in PolarDB IMCI. Column pruning, optimizer settings, and hybrid execution tips.

#polardb
#databases
#optimization

1 answer• 1 view

12/31/2025, 11:53 AM

Databases Speed Up Power Query: Diagnose & Optimize Performance

Step‑by‑step guide to diagnosing Power Query slowness—from filtering and Folder.Files to memory tuning, using Power BI for large file sets, and best practices.

#power-query
#excel
#sharepoint
#performance
#optimization

1 answer• 1 view

12/12/2025, 08:46 PM