Energy Consumption of SQL Queries with and without LIMIT clause in Python

This dataset contains energy consumption measurements collected using EnergyTracer. It compares the execution of a Python script containing a specific code smell (SQL query without LIMIT) against a refactored version with a LIMIT clause. Research Question How significant is the energy consumption difference between a SQL query executed without any limit and the same query executed with a LIMIT clause, in Python? Measurement Tool: EnergyTracer. Statistical analysis: Welch's t-test (α = 0.05) and Cohen's d effect size. Instances Instance Hardware OS Architecture Apple Mac Mini Apple M4 Darwin 25.3.0 arm64 aws-c8a.large AMD EPYC 9R45 Amazon Linux 2023 x86_64 aws-m7a.large AMD EPYC 9R14 Amazon Linux 2023 x86_64 aws-r8a.large AMD EPYC 9R45 Amazon Linux 2023 x86_64 Full reproduction instructions are available in the EnergyTracer repository. The README.md included in this dataset details the file structure and column dictionary.