This is an interesting topic more belonging to the realms of information
theory and statistical physics.
I am not an expert in this area but from what I recall from
undergraduate physics the moment you create order in one corner of the
universe entropy rises in another place of the universe. If you loosely
speaking equate information gathering such as an SQL query as creating
order then that must have a cost in terms of increasing the entropy
(heat in this case) elsewhere. There is a lower bound on how little
entropy is generated during this process which comes down to the
efficiency of the process (hardware and software in your case).
One could get philosophical here and question whether mankinds computer
modeling of climate change in itself causes the excess heat leading to
global warming.
Regards,
Robert
--
Robert Oeffner, Ph.D.
Research Associate,
The Read Group, Department of Haematology,
Cambridge Institute for Medical Research
University of Cambridge
Cambridge Biomedical Campus
Wellcome Trust/MRC Building
Hills Road
Cambridge CB2 0XY
www.cimr.cam.ac.uk/investigators/read/index.html
Date: Tue, 21 Nov 2017 09:54:25 +1100
From: Ali Dorri <alidorri...@gmail.com>
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: [sqlite] Energy consumption of SQLite queries
Message-ID:
<CAOB3cEGoh=pnp2syjegouoqcve2+q35s99pt4lzx_cu_6uc...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Dear All,
I am doing a research on the energy consumed by a query in SQLite. I
have a
program which fills a database with blocks of data. Then, it attempts
to
remove some data from the database. I don't know how to measure the
energy
consumed from my host, i.e., my laptop which has both the SQLite and
the
program, from the time I generated the query till the query is finished
and
control returns back to my program.
Any help is highly appreciated.
Regards
Ali
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
