Re: [sqlite] Energy consumption of SQLite queries

2017-11-21 Thread Roman Fleysher
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

Re: [sqlite] Energy consumption of SQLite queries

2017-11-21 Thread Ali Dorri
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

Re: [sqlite] Energy consumption of SQLite queries

2017-11-21 Thread Robert Oeffner
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.

Re: [sqlite] Energy consumption of SQLite queries

2017-11-21 Thread Paul Sanderson
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.

Re: [sqlite] Energy consumption of SQLite queries

2017-11-20 Thread Simon Slavin
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

Re: [sqlite] Energy consumption of SQLite queries

2017-11-20 Thread Keith Medcalf
>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

Re: [sqlite] Energy consumption of SQLite queries

2017-11-20 Thread petern
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

Re: [sqlite] Energy consumption of SQLite queries

2017-11-20 Thread Ali Dorri
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

Re: [sqlite] Energy consumption of SQLite queries

2017-11-20 Thread R Smith
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