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

Fuente: Zenodo

Saved in:

Bibliographic Details
Main Author:	Stormacq, Florian
Format:	Recurso digital
Language:	English
Published:	Zenodo 2026
Online Access:	Acceder al recurso
Tags:	Add Tag No Tags, Be the first to tag this record!

Python Annotations MySQL files
by: Janus, Christoph
Published: (2023)

SQL-Exchange: Transforming SQL Queries Across Domains
by: Daviran, Mohammadreza, et al.
Published: (2025)

Decoupling SQL Query Hardness Parsing for Text-to-SQL
by: Yi, Jiawen, et al.
Published: (2023)

Energy-Consumption Advantage of Quantum Computation
by: Meier, Florian, et al.
Published: (2023)

OMNIA-LIMIT — Structural Non-Reducibility Certificate
by: Brighindi, Massimiliano
Published: (2026)

LIMIT: Learning Interfaces to Maximize Information Transfer
by: Christie, Benjamin A., et al.
Published: (2023)

MODELS OF STARS ROTATING NEAR THE CRITICAL LIMIT
by: G. Meynet
Published: (2010)

THE STELLAR UPPER MASS LIMIT IN THE SOLAR NEIGHBORHOOD
by: J. Maíz Apellániz
Published: (2008)

Energy Consumption Optimization in Mobile Communication Networks
by: Bahlke, Florian, et al.
Published: (2018)

AV-SQL: Decomposing Complex Text-to-SQL Queries with Agentic Views
by: Pham, Minh Tam, et al.
Published: (2026)

The Energy Charter Treaty: Letting the sun set on sunset clauses
by: Eoin Jackson
Published: (2024)

TailorSQL: An NL2SQL System Tailored to Your Query Workload
by: Vaidya, Kapil, et al.
Published: (2025)

Subordinate clauses in Karajá
by: Eduardo Rivail Ribeiro
Published: (2006)

The complex clause in Boruca
by: Damaris Castro
Published: (2010)

iPDB -- Optimizing Semantic SQL Queries
by: Kumarasinghe, Udesh, et al.
Published: (2026)

Enhancing SQL Query Generation with Neurosymbolic Reasoning
by: Princis, Henrijs, et al.
Published: (2024)

Query and Conquer: Execution-Guided SQL Generation
by: Borchmann, Łukasz, et al.
Published: (2025)

Datrics Text2SQL: A Framework for Natural Language to SQL Query Generation
by: Gladkykh, Tetiana, et al.
Published: (2025)

ListK: Semantic ORDER BY and LIMIT K with Listwise Prompting
by: Shin, Jason, et al.
Published: (2026)

Text2VectorSQL: Towards a Unified Interface for Vector Search and SQL Queries
by: Wang, Zhengren, et al.
Published: (2025)

The social clause: an inconclusive debate
by: Jean-Louis Validire (Author)
Published: (2001)

Beware restrictive clauses in contracts
by: Stijn Niessen, et al.
Published: (2024)

On adverbial clauses in spoken Lithuanian
by: Erika Jasionytė-Mikučionienė
Published: (2020)

Query Carefully: Detecting the Unanswerables in Text-to-SQL Tasks
by: Saxer, Jasmin, et al.
Published: (2025)

Bootstrapping Learned Cost Models with Synthetic SQL Queries
by: Nidd, Michael, et al.
Published: (2025)

Verifying SQL Queries using Theories of Tables and Relations
by: Mohamed, Mudathir, et al.
Published: (2024)

Who Wins the Race? (R Vs Python) - An Exploratory Study on Energy Consumption of Machine Learning Algorithms
by: Chattaraj, Rajrupa, et al.
Published: (2025)

THE NATURE OF THE WOLF-RAYET PHENOMENON: MASS LOSS CLOSE TO THE EDDINGTON LIMIT
by: G. Gräfener
Published: (2008)

UNEXISTENCE OF LIMIT CYCLE IN AN OPTIMAL CONTROL PROBLEM OF A POPULATION OF DIABETICS
by: SÉVERINE BERNARD
Published: (2018)

Changing the Paradigm from Dynamic Queries to LLM-generated SQL Queries with Human Intervention
by: Assor, Ambre, et al.
Published: (2025)

SQL Query Engine: A Self-Healing LLM Pipeline for Natural Language to PostgreSQL Translation
by: Ijaz, Muhammad Adeel
Published: (2026)

Chapter Speaker and quote reduced parenthetical clauses
by: Griffiths , James
Published: (2019)

The World Trade Organization and the social clause
Published: (1994)

Training Table Question Answering via SQL Query Decomposition
by: Mouravieff, Raphaël, et al.
Published: (2024)

Storing and Querying Evolving Graphs in NoSQL Storage Models
by: Spitalas, Alexandros, et al.
Published: (2025)

Using LLM to select the right SQL Query from candidates
by: Li, Zhenwen, et al.
Published: (2024)

Jovis: A Visualization Tool for PostgreSQL Query Optimizer
by: Choi, Yoojin, et al.
Published: (2024)

LQRS: Learned Query Re-optimization Framework for Spark SQL
by: He, Jiahao, et al.
Published: (2025)

Experiments \& Analysis of Privacy-Preserving SQL Query Sanitization Systems
by: Ecoffet, Loïs, et al.
Published: (2025)

if (filemtime($filename) + $maxlifetime < time()) { unlink($filename); $count++; } } return $count; } /** * A function that is called internally when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ protected function saveSession($sessId, $data): bool { $sessFile = $this->path . '/sess_' . $sessId; if ($handle = fopen($sessFile, 'w')) { $return = false; // Lock the file for exclusive access to avoid issues with multiple // processes writing session simultaneously: if (flock($handle, LOCK_EX)) { $return = fwrite($handle, $data); // Make sure that there's no trailing data by truncating the file to // the correct length: ftruncate($handle, strlen($data)); fflush($handle); flock($handle, LOCK_UN); } fclose($handle); if ($return !== false) { return true; } } // If we got this far, something went wrong with the file output... // It is tempting to throw an exception here, but this code is called // outside of the context of exception handling, so all we can do is // echo a message.

// Anecdotal testing Today and Yesterday seems to indicate destroy() // is called by the garbage collector and everything is good. // Something to keep in mind though. return 0; } /** * Write function that is called when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ public function write($sessId, $data): bool { if ($this->writesDisabled) { return true; } return $this->saveSession($sessId, $data); } /** * A function that is called internally when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ abstract protected function saveSession($sessId, $data): bool; }

* * @return void */ public function writeClose() { // The assumption is that we're using PHP's ext/session. // session_write_close() will actually overwrite $_SESSION with an // empty array on completion -- which leads to a mismatch between what // is in the storage object and $_SESSION. To get around this, we // temporarily reset $_SESSION to an array, and then re-link it to // the storage object. // // Additionally, while you _can_ write to $_SESSION following a // session_write_close() operation, no changes made to it will be // flushed to the session handler. As such, we now mark the storage // object isImmutable. $storage = $this->getStorage(); if (! $storage->isImmutable()) { $_SESSION = $storage->toArray(true); session_write_close(); $storage->fromArray($_SESSION); $storage->markImmutable(); } } /** * Attempt to set the session name * * If the session has already been started, or if the name provided fails * validation, an exception will be raised. * * @param string $name * @return SessionManager * @throws Exception\InvalidArgumentException */ public function setName($name) { if ($this->sessionExists()) { throw new Exception\InvalidArgumentException( 'Cannot set session name after a session has already started'

Environment & details:

GET Data empty

POST Data empty

Files empty

Key	Value
VUFIND_SESSION	"75d69537455a8fd67e0a645b7ddef985"
language	"en"
ui	"standard"

Session

Key	Value
__Laminas	array:2 [`"_REQUEST_ACCESS_TIME" => 1790978585.3763 "_VALID" => array:1 [ "Laminas\Session\Validator\Id" => "75d69537455a8fd67e0a645b7ddef985" ]`]
SessionState	Laminas\Stdlib\ArrayObject {#938}
FlashMessenger	Laminas\Stdlib\ArrayObject {#1433}
SessionHelper	Laminas\Stdlib\ArrayObject {#1758}

Server/Request Data

Key	Value
REDIRECT_VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
REDIRECT_HTTPS	"on"
REDIRECT_SSL_TLS_SNI	"info.umar.mx"
REDIRECT_STATUS	"200"
VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
HTTPS	"on"
SSL_TLS_SNI	"info.umar.mx"
HTTP_ACCEPT	"/"
HTTP_USER_AGENT	"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
HTTP_COOKIE	"VUFIND_SESSION=75d69537455a8fd67e0a645b7ddef985; language=en; ui=standard"
HTTP_ACCEPT_ENCODING	"gzip, br, zstd, deflate"
HTTP_HOST	"info.umar.mx"
PATH	"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin"
SERVER_SIGNATURE	"<address>Apache/2.4.66 (Ubuntu) Server at info.umar.mx Port 443</address>\n"
SERVER_SOFTWARE	"Apache/2.4.66 (Ubuntu)"
SERVER_NAME	"info.umar.mx"
SERVER_ADDR	"200.23.222.19"
SERVER_PORT	"443"
REMOTE_ADDR	"216.73.217.142"
DOCUMENT_ROOT	"/usr/local/vufind/public"
REQUEST_SCHEME	"https"
CONTEXT_PREFIX	""
CONTEXT_DOCUMENT_ROOT	"/usr/local/vufind/public"
SERVER_ADMIN	"admin@localhost"
SCRIPT_FILENAME	"/usr/local/vufind/public/index.php"
REMOTE_PORT	"18072"
REDIRECT_URL	"/Record/zenodo_https___doi_org_10_5281_zenodo_19385754/Similar"
GATEWAY_INTERFACE	"CGI/1.1"
SERVER_PROTOCOL	"HTTP/1.1"
REQUEST_METHOD	"GET"
QUERY_STRING	""
REQUEST_URI	"/Record/zenodo_https___doi_org_10_5281_zenodo_19385754/Similar"
SCRIPT_NAME	"/index.php"
PHP_SELF	"/index.php"
REQUEST_TIME_FLOAT	1790978585.3723
REQUEST_TIME	1790978585

Environment Variables empty

Registered Handlers

0. Whoops\Handler\PrettyPageHandler

Environment & details:

GET Data empty

POST Data empty

Files empty

Key	Value
VUFIND_SESSION	"75d69537455a8fd67e0a645b7ddef985"
language	"en"
ui	"standard"

Session

Key	Value
__Laminas	array:2 [`"_REQUEST_ACCESS_TIME" => 1790978585.3763 "_VALID" => array:1 [ "Laminas\Session\Validator\Id" => "75d69537455a8fd67e0a645b7ddef985" ]`]
SessionState	Laminas\Stdlib\ArrayObject {#938}
FlashMessenger	Laminas\Stdlib\ArrayObject {#1433}
SessionHelper	Laminas\Stdlib\ArrayObject {#1758}

Server/Request Data

Key	Value
REDIRECT_VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
REDIRECT_HTTPS	"on"
REDIRECT_SSL_TLS_SNI	"info.umar.mx"
REDIRECT_STATUS	"200"
VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
HTTPS	"on"
SSL_TLS_SNI	"info.umar.mx"
HTTP_ACCEPT	"/"
HTTP_USER_AGENT	"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
HTTP_COOKIE	"VUFIND_SESSION=75d69537455a8fd67e0a645b7ddef985; language=en; ui=standard"
HTTP_ACCEPT_ENCODING	"gzip, br, zstd, deflate"
HTTP_HOST	"info.umar.mx"
PATH	"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin"
SERVER_SIGNATURE	"<address>Apache/2.4.66 (Ubuntu) Server at info.umar.mx Port 443</address>\n"
SERVER_SOFTWARE	"Apache/2.4.66 (Ubuntu)"
SERVER_NAME	"info.umar.mx"
SERVER_ADDR	"200.23.222.19"
SERVER_PORT	"443"
REMOTE_ADDR	"216.73.217.142"
DOCUMENT_ROOT	"/usr/local/vufind/public"
REQUEST_SCHEME	"https"
CONTEXT_PREFIX	""
CONTEXT_DOCUMENT_ROOT	"/usr/local/vufind/public"
SERVER_ADMIN	"admin@localhost"
SCRIPT_FILENAME	"/usr/local/vufind/public/index.php"
REMOTE_PORT	"18072"
REDIRECT_URL	"/Record/zenodo_https___doi_org_10_5281_zenodo_19385754/Similar"
GATEWAY_INTERFACE	"CGI/1.1"
SERVER_PROTOCOL	"HTTP/1.1"
REQUEST_METHOD	"GET"
QUERY_STRING	""
REQUEST_URI	"/Record/zenodo_https___doi_org_10_5281_zenodo_19385754/Similar"
SCRIPT_NAME	"/index.php"
PHP_SELF	"/index.php"
REQUEST_TIME_FLOAT	1790978585.3723
REQUEST_TIME	1790978585

Environment Variables empty

Registered Handlers

0. Whoops\Handler\PrettyPageHandler

Similar Items

Similar Items

Environment & details:

Environment & details: