amremaish / index_defeating_expressionsView external linksLinks
A comprehensive guide to SQL query optimization focusing on expressions that defeat database indexes. Covers 20 common anti-patterns with practical solutions for PostgreSQL, MySQL, and SQL Server. Includes examples of sargable vs non-sargable queries, functional indexes, and performance optimization techniques
☆17Aug 24, 2025Updated 5 months ago
Alternatives and similar repositories for index_defeating_expressions
Users that are interested in index_defeating_expressions are comparing it to the libraries listed below
Sorting:
- A powerful Laravel storage driver that enables seamless synchronization of files across multiple disks, with an integrated cache disk for…☆15Nov 11, 2025Updated 3 months ago
- 🐆A lightweight, high-performance string manipulation library optimized for speed-sensitive applications.☆14Jan 6, 2026Updated last month
- The SEAL-CPU backend is a Reference backend engine for HEBench which is a shared library that implements the required functions specified…☆11Mar 3, 2023Updated 2 years ago
- Sparse Matrix Factorization (SMF) is a key component in many machine learning problems and there exist a verity a applications in real-w…☆11Jan 25, 2016Updated 10 years ago
- An experimental python library to compile and analyze the cost of any desired composite simulation in real or imaginary time, and with or…☆10Feb 9, 2024Updated 2 years ago
- A curated collection of practical Laravel tips, tricks, and best practices to help you write cleaner, faster, and more efficient code. Wh…☆10Apr 13, 2025Updated 10 months ago
- The High Performance Collision Cross Section (HPCCS) is a new software for fast and accurate calculation of CCS for molecular ions. Based…☆17May 11, 2020Updated 5 years ago
- ☆10Nov 22, 2022Updated 3 years ago
- My personal dotfiles with automated macOS setup. Features smart installation scripts, Bats testing (bash), performance monitoring, and 2…☆11Feb 6, 2026Updated last week
- Tlama (124M) is a language model based on LlaMa3 (127M) optimized by EigenCore. It is designed for computational efficiency and scalabili…☆12Mar 27, 2025Updated 10 months ago
- This project involves using Simulink to create a comprehensive battery model that incorporates both charging and discharging resistances.…☆11Apr 30, 2023Updated 2 years ago
- Discover Netflix's Open Connect Appliance (OCA) assigned to your connection. This tool fetches and displays detailed connectivity and hos…☆18Jul 22, 2025Updated 6 months ago
- optimize TCP settings and download speeds of applications on Windows systems for improved network performance☆11Apr 29, 2025Updated 9 months ago
- Just simple JavaScript framework. Provides support for manipulating with DOM and events handling. Easy for use, optimized for performance…☆11Feb 15, 2017Updated 9 years ago
- Portfolio and blog for my online brand. Performance Optimized Single Page React App.☆11Nov 7, 2016Updated 9 years ago
- Incremental optimizations to the N-Body problem in order to evaluate and compare the performance of Python translators in the HPC environ…☆13Apr 2, 2023Updated 2 years ago
- A magisk module that optimizes your device's memory performance through persistent zRAM + Swapfile optimization with VM tweaks.☆11Jun 1, 2025Updated 8 months ago
- 💾 Optimize Laravel caching with Cachetastic! Cache method results, force refresh, handle errors, and boost app performance effortlessly.☆13Jan 26, 2026Updated 3 weeks ago
- This workshop teaches systematic approaches to evaluating Generative AI workloads for production use. You'll learn to build evaluation fr…☆26Updated this week
- A powerful image optimization tool that reduces file sizes while maintaining quality. It supports compression, resizing, and format conve…☆10Sep 21, 2024Updated last year
- Backpack Attachments is a FiveM resource for attaching weapons and items to players' backs. It supports customizable attachment points, h…☆10Nov 14, 2024Updated last year
- 💰 Save money on AI API costs! 76% token reduction, Auto-Fix token limits, Universal AI compatibility. Cline • Copilot • Claude • Curs…☆22Jun 18, 2025Updated 8 months ago
- How would you predict the compressive strength of concrete as a function of its constituent materials and curing time? In this portfolio …☆12Nov 27, 2020Updated 5 years ago
- My portfolio showcases impressive web projects with attractive designs, versatile functionalities, and optimized performance, highlightin…☆11Jun 9, 2023Updated 2 years ago
- Adds a Doctrine Id generator which uses an ordered UUID in MySQL for extra performance. Uses methods described in Karhik Appigatla's arti…☆10Jun 8, 2015Updated 10 years ago
- A comprehensive guide to installing and configuring Roblox Studio using Vinegar from Flatpak, including model integration and performance…☆19Mar 22, 2025Updated 10 months ago
- A Particle System implemented in android, handling collinsions, optimized for performance☆10Dec 18, 2023Updated 2 years ago
- DATAVIEW is a big data workflow management system. It uses Dropbox as the data cloud and Amazon EC2 as the compute cloud. Current researc…☆11Jun 11, 2022Updated 3 years ago
- Restaurant Management System is a web application built with Next.js and TypeScript. It offers features for restaurant management, includ…☆14May 1, 2025Updated 9 months ago
- Membrane-based dehumidification is currently being considered as a promising solution for the building application due to its low cost an…☆10Oct 28, 2020Updated 5 years ago
- A high-performance Model Context Protocol server for AI integration with Metabase analytics platforms. Features response optimization, ro…☆41Feb 1, 2026Updated 2 weeks ago
- A lightweight React hook that automatically manages fade overlays for scrollable containers. Provides smooth gradient transitions at the …☆11Aug 11, 2025Updated 6 months ago
- Proxima is a Node.js and Express API that provides basic CRUD functionality for managing data resources. It supports GET, POST, PATCH, an…☆11Jun 8, 2023Updated 2 years ago
- The optimization field suffers from the metaphor-based “pseudo-novel” or “fancy” optimizers. Most of these cliché methods mimic animals' …☆12Oct 13, 2024Updated last year
- This project is a real-time Wav2Lip implementation that I am actively optimizing to enhance the precision and performance of audio-to-lip…☆11Dec 6, 2023Updated 2 years ago
- A modern, lightweight CRM platform built with performance and customization in mind. Designed for businesses to efficiently manage client…☆28Jun 3, 2025Updated 8 months ago
- 💻 As a Frontend Development Intern at Shen AI (Aug – Oct 2024), I built the company website using React.js and worked with the design te…☆13May 15, 2025Updated 9 months ago
- Repo for Li, Kafka, Gao et al 2019 "Clustering discretization methods for generation of material performance databases in machine learni…☆14May 27, 2019Updated 6 years ago
- High-performance integer factorization suite implementing GNFS, MPQS, and QS algorithms with optimized lattice reduction, vectorization, …☆10Jan 14, 2026Updated last month