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 <d...@sqlite.org> wrote: > On 2/9/17, Bart Smissaert <bart.smissa...@gmail.com> 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 > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
