If you're talking about Database Browser for SQLite (formally named SQLite
Database Browser), at least at one time (version 3.5) it executed each query
twice, apparently the first time to figure out the return types, and the second
time to display the results (this caused me a certain amount of trouble until I
realized the initialization function for my extension was being run twice by
SELECT load_extension, and I fixed the function to be OK with being run
multiple times). ?It wouldn't explain a 3x+ slowdown, but would explain a 2x
anyway.
Peter
On Friday, August 28, 2015 7:45 AM, "Rousselot, Richard A"
<Richard.A.Rousselot at centurylink.com> 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
