SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
FR: SQLite timer

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
FR: SQLite timer
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post FR: SQLite timer Reply with quote
It would be great if there was a way to use an SQL timer for queries in SQLite databases like the one that is turned on/off with the dot-command .timer in sqlite3.exe command-line executable.
Fri Sep 25, 2015 4:27 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Please try Alt+F12 or alternatively SQL Assistant -> Execute/Schedule SQL -> Show SQL History menu

It will show all executed SQL statements, when they were executed and their execution time. Not exactly the same as ".timer on" but very similar and database type independent.


Last edited by SysOp on Sat Sep 26, 2015 2:05 pm; edited 1 time in total
Sat Sep 26, 2015 1:58 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post Reply with quote
Good to know. I'll use that, thank you very much.
Sat Sep 26, 2015 2:02 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.