search

yy0931 / sqlite3-editor

https://marketplace.visualstudio.com/items?itemName=yy0931.vscode-sqlite3-editor
GNU General Public License v3.0
838 stars 6 forks source link

Execution time for query #62

Closed adas291 closed 2 months ago

adas291 commented 2 months ago

First of all spectacular extension. I know that project development slowed down as the following line in latest commit was removed "Feel free to report any issues or feature requests" was removed. I would kindly (and not "freely") ask, is there a way to implement execution time of query? Sometimes this would really help when optimizing new queries.

yy0931 commented 2 months ago

Do you mean you want to check the duration it took to run a SQL query? If so, I remember I didn't implement that feature because it could be misleading;

  1. The extension doesn't run the user's query as-is. It fetches only the visible rows when running a SELECT statement, but when fetching the first row was significantly slower than fetching subsequent rows, fetches more rows and caches them.
  2. Also, because of SQLite' caching, the first run of a query can sometimes be significantly slower than the second run.