On 2015-08-28 04:45 PM, Rousselot, Richard A wrote: > I have noticed that SQLite Query Browser is running slower than other IDEs, > including SQLitespeed, for some reason. Even when each IDE is set to using > similar versions of the SQLite3.dll. We had a recursive query in SQB take 6 > min, on other IDEs it would be less than 2 min. > > My $0.02
Also, opening a DB with a hot journal will take some time (such as when a previous query was process-killed), the command-line and different browser IDE's might do this at different stages of the user-input and it might cause significant differences in observed duration.