This wasn't a prepare and execute. Prepare and execute takes some 5 seconds on my machine. What I saw took 1.4 secs. I think there must have been other overhead and this wasn't just a prepare. Will check.
RBS On Thu, Feb 9, 2017 at 10:13 AM, Richard Hipp <[email protected]> wrote: > On 2/9/17, Bart Smissaert <[email protected]> wrote: > > I have seen a prepare take over a second. > > Take for example this recursive Sudoku SQL: > > > > I think you are confusing "prepare" with "prepare and execute". The > prepare for the SQL query you provided takes less than 60 microseconds > on my desktop. > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
