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 method incurred on the host node that is running the program. I measured the time consumed by measuring the time difference before and after running the query and I need to do the same (somehow) for the energy consumption. I just need to give a rough estimation. Of course, the exact values depend on many options, but I need to show something.
Hope this helps. Many thanks Ali On Tue, Nov 21, 2017 at 10:26 AM, R Smith <rsm...@rsweb.co.za> wrote: > 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. >> > > I'm sure you have a good reason to want to do this, but I think it's not a > worthy pursuit. > > It's a bit like trying to measure the amount of Energy a road uses. The > answer is simple: It depends very much on which vehicles drive on it. The > road doesn't use energy, it's just a venue or method used by machines who > themselves consume the energy based on how efficient THEY are. Sure a > longer or more curvy road will require more energy than a shorter road, so > you can get COMPARATIVE or scaled energy ratios for different length roads > for similar vehicles perhaps, but in the end quantifying that "road A uses > X energy" will be patently false. > > Similarly, SQLite's energy usage depends on the TDP and energy > coefficients of the machine it is running on. > > If you want to know how SQLite stacks up against another database or > storage mechanism (possibly in terms of who uses more battery power from > the phone it runs on) then you can simply measure the cycles/FPO's of both > test subjects and there's programs out there to do that with for every > platform. (SQLite will likely beat anything else by a mile for equal data > handling ops). > > This will give you a great ratio of energy usage against whatever else it > is measured, but measuring quantified physical energy usage is merely an > arbitration of the machine it is running on, it has no intrinsic value as a > stand-alone figure. > > > Tell us more of your specific goals, maybe someone here has a way... > > Cheers, > Ryan > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
