From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of
Ali Dorri [alidorri...@gmail.com]
Sent: Tuesday, November 21, 2017 4:49 PM
To: Robert Oeffner
Cc: SQLite mailing list
Subject: Re: [sqlite] Energy consumption of SQLite queries
Dear All,
Thanks for your comments
Dear All,
Thanks for your comments. That was really helpful.
Regards
Ali
On Tue, Nov 21, 2017 at 11:41 PM, Robert Oeffner wrote:
> This is an interesting topic more belonging to the realms of information
> theory and statistical physics.
>
> I am not an expert in this area
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.
A pretty much impossible task I would think.
The power usage of SQLite compared to the power usage of different hardware
components would be miniscule. But, there are so many other tasks running
on a system, many in the background, that isolating SQLite from the rest
would be next to impossible.
On 20 Nov 2017, at 10:54pm, Ali Dorri wrote:
> 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
>Considering how total energy of computation is entirely liberated as heat
Human technology at its current primitive state converts ALL energy usage into
heat.
At scale you call this is called "global warming" and it is an inherent process
-- at least until humans figure out how to convert
Energy measurement can be carried out with a recording electric power meter
provided the power otherwise consumed by the operating system and other
programs can be controlled for. Total energy used by the computer during
one trial is computed by the integral of the recorded power reading over
Dear Ryan,
Thanks for your response.
As you said the energy completely depends on the machine, but that is fine
for our experiment. We are not comparing SQLite with other databases. I am
a researcher and I've developed a system which uses a database. My aim is
to see how much time and energy my
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
9 matches
Mail list logo