jeudi 7 janvier 2016

How to find out execution time of sqlite query?

First thing: Please read the question details before marking this as a duplicate.

I am using sqlite db with JAVA. Here's what I have already tried:

  1. I have tracked query times using start and end time from within JAVA code. But I want more accurate data.
  2. I have also tracked time using sqlite browser. But in sqlite browser, total time i.e. time to fetch data + time to plot data comes.

I want only the time that it takes to find and fetch data.

How can I find out the fetch time? I have to make a decision based on the actual time values, whether it will be beneficial for us to use sqlite db.

Aucun commentaire:

Enregistrer un commentaire