Hello, I am facing a strange issue: I am calling sqlite3_execute(db, "ANALYZE;") from a C program after a bunch of CREATE and INSERT, Then this program exits. Another exe tries to perform some selects into the db, but it seems like ANALYZE had no effect and the queries take about 10 mn to complete.
Now if I run ANALYZE on the db from sqlitestudio, the selects get blazing fast: about 1 second or less. I have no idea why this is beheaving like that. Thank you in advance if you have any clue. Kind regards Ludovic
