how to find out the execution time of Sqlite query in android

Question

I'm trying to optimize the performance of my Sqlite queries.

I wanted to know if there is any way to find the execution time of each Sqlite statement, or if there is any tool that allows to view the statement execution time in Android SDK?

Although I'm familiar with .timer On and .timer show commands for Query timer.

Example:

Any answer is truly appreciated!

Answer 1

You could do this in Java:

int startTime = System.currentTimeMillis();

... // Execute the query here

int executionTime = System.currentTimeMillis() - startTime; // This variable now contains the time taken by the query, in milliseconds