10 repositorios
Tools and patterns for optimizing database query performance and indexing.
Distinguishing note: Focuses on application-level performance tuning, not database administration.
Explore 10 awesome GitHub repositories matching data & databases · Database Performance Utilities. Refine with filters or upvote what's useful.
Claude-mem is an agentic memory persistence system designed to provide AI assistants with long-term context across multiple development sessions. It functions as a background orchestrator that captures, summarizes, and indexes interaction history, allowing models to maintain continuity and recall technical decisions from past tasks. By utilizing a vector-augmented context engine, the system injects relevant historical observations into active sessions, ensuring that AI agents remain informed without exceeding finite token budgets. The project distinguishes itself through an endless memory arc
Optimizes database performance using prepared statements, virtual tables, and index-first result formats.
This is a reference implementation library providing a collection of code samples, Transact-SQL scripts, and schemas for SQL Server, Azure SQL, and Azure Synapse. It focuses on providing standardized implementation patterns and reference code for building relational databases and cloud data warehouses. The library distinguishes itself by offering specialized guides and examples for deploying database instances within containerized environments and Azure cloud services. It includes specific reference databases and language extensions for integrating machine learning services and advanced analy
Implements performance testing to measure memory and disk retrieval speeds for optimizing data processing.
TechEmpower FrameworkBenchmarks is an open-source project that provides a standardized, reproducible suite for measuring and comparing the performance of web frameworks across many languages. At its core, it defines a set of common server-side tasks—such as JSON serialization, database queries, and server-side template rendering—and executes them uniformly against hundreds of framework implementations to produce comparable throughput and latency metrics. The project is built around a multi-language benchmark harness that automates the full test lifecycle, from dependency installation and serve
Tests measuring database read, write, and query performance across multiple database backends.
This project is a suite of analytical tools for quantifying web performance, specifically designed for benchmarking the rendering speed and memory usage of various JavaScript frameworks. It provides a standardized set of DOM manipulation tests and a comparison tool that uses weighted geometric means to measure efficiency across different web implementations. The benchmark harness distinguishes itself by providing deep analysis of DOM reconciliation strategies, comparing the performance and correctness of keyed versus non-keyed rendering. It also includes a memory profiler for tracking allocat
Provides a reporting system that compares the speed and scalability of different web framework implementations.
better-sqlite3 is a high-performance SQLite3 client for Node.js that executes queries synchronously, returning results directly without callbacks or promises. It compiles as a native addon using N-API, binding directly to the SQLite3 C library for immediate query execution and zero-copy result serialization into native JavaScript objects. The library is optimized for Write-Ahead Logging (WAL) mode, enabling faster concurrent reads and writes in web applications. It provides durability level tuning through the synchronous pragma, allowing adjustments between FULL, NORMAL, and OFF modes to bala
Processes queries efficiently on multi-gigabyte SQLite3 databases with proper indexing and joins.
This project is a web framework performance benchmark suite and automated benchmarking orchestrator. It serves as a multi-language performance analysis tool designed to measure execution speed, throughput, and latency across various HTTP libraries and programming ecosystems. The system functions as an HTTP framework comparison tool that evaluates relative efficiency using consistent hardware and request patterns. It automates the build, deployment, and execution cycles necessary to collect stable performance data and compute metrics such as error rates and latency percentiles. The suite eval
Provides standardized benchmarks to compare the speed and scalability of different web frameworks.
sysbench is a database and system benchmark tool used to measure the throughput and latency of database systems and hardware components. It functions as a multi-threaded workload generator and hardware performance profiler designed to determine how systems perform under heavy load. The project serves as a scriptable benchmark engine, allowing for the definition of custom performance scenarios through scripts. It simulates real-world traffic patterns by generating random data based on mathematical probability distributions, such as Zipfian, Gaussian, or Pareto. Capabilities cover database per
Measures throughput and latency by running synthetic workloads and transactions against database systems to test speed and scalability.
SQLAdvisor es un afinador de rendimiento de bases de datos y herramienta de recomendación de índices diseñada para reducir la latencia de las consultas. Funciona como un optimizador de consultas que analiza los patrones de ejecución de SQL para identificar índices faltantes y proporcionar consejos de optimización de rendimiento accionables. El sistema se centra en la gestión automatizada de índices y el ajuste de consultas de bases de datos. Identifica las causas raíz de las respuestas lentas de la base de datos y recomienda los índices más efectivos para mejorar las velocidades de recuperación de datos. Sus capacidades incluyen el análisis de árboles de análisis SQL y patrones de unión, utilizando modelos de costos y selecciones basadas en heurística para priorizar los índices. La herramienta integra la optimización consciente del esquema para evitar recomendaciones de índices redundantes mientras reduce los costos de escaneo.
Reduces query latency by identifying missing indexes based on actual SQL execution patterns.
Este proyecto proporciona un envoltorio de C++ solo de cabecera para la Node-API, sirviendo como marco para construir complementos nativos de alto rendimiento para Node.js. Actúa como un puente entre C++ y JavaScript, ofreciendo una interfaz orientada a objetos que simplifica la creación de extensiones compiladas mientras gestiona las complejidades del límite del lenguaje. La biblioteca se distingue por proporcionar abstracciones seguras de tipos para la organización de datos y la gestión de memoria, asegurando que los objetos nativos y del lado del script sean rastreados y reclamados correctamente. Incluye mecanismos para coordinar tareas asíncronas entre hilos en segundo plano y el bucle de eventos principal, evitando la corrupción de datos mientras se descargan cálculos intensivos. Además, mapea las excepciones nativas a tipos de error de script estándar, asegurando informes de diagnóstico consistentes y manejo de fallas. Más allá de sus capacidades de puente central, el proyecto admite el ciclo de vida completo del desarrollo nativo, incluida la exposición de clases y métodos de C++ al tiempo de ejecución de JavaScript. Proporciona herramientas para gestionar ciclos de vida de entornos, automatizar migraciones de código y ejecutar puntos de referencia de rendimiento para evaluar el comportamiento de los componentes nativos.
Provides utilities for measuring and comparing the performance of native code components.
Realm Kotlin is a local, object-oriented NoSQL database engine designed for Kotlin Multiplatform applications. It enables developers to persist structured application data directly as objects, eliminating the need for traditional relational table structures while ensuring information remains accessible during offline periods. The library distinguishes itself through a compiler-plugin-based architecture that maps standard language classes to database models at compile time. It utilizes zero-copy memory mapping and a lazy-loading query engine to manage data efficiently, while a shared C++ core
Includes integrated microbenchmarking tools for mobile devices to track execution speed and identify performance bottlenecks.