Re: [sqlite] Question about sqlite3_prepare vs sqlite3_prepare_v2

2018-05-08 Thread Richard Hipp
Can you post, or send by private email, the output from ".fullschema --indent" from the sqlite3 command-line shell on your database file? On 5/8/18, Charles Leifer wrote: > Hi, > > I was debugging some discrepancies in execution times of some queries using > the Python 3.6 standard library sqlite

[sqlite] Question about sqlite3_prepare vs sqlite3_prepare_v2

2018-05-08 Thread Charles Leifer
Hi, I was debugging some discrepancies in execution times of some queries using the Python 3.6 standard library sqlite3 driver. I was wondering if these discrepancies could be explained by the fact that the Python sqlite3 driver is using the legacy sqlite3_prepare interface? Just to be clear: I d