Dear All, Thanks for your comments. That was really helpful.
Regards Ali On Tue, Nov 21, 2017 at 11:41 PM, Robert Oeffner <rob...@oeffner.net> 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 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.gm >> ail.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
