This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

Author erlendaasland
Recipients elfring, erlendaasland, ghaering, zzzeek
Date 2021-05-09.08:17:00
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1620548220.41.0.153714200843.issue22956@roundup.psfhosted.org>
In-reply-to
Content
As Gerhard said in msg233384, there is already a statement cache. sqlite3_prepare_v2() is only called if the statement is not found in the cache.

Current behaviour:
>>> import sqlite3
>>> cx = sqlite3.connect(":memory:")
>>> cu = cx.cursor()
>>> cu.execute("select 1")  # sqlite3_prepare_v2() called
>>> cu.execute("select 1")  # sqlite3_prepare_v2() is _not_ called


Suggesting to close this issue.
History
Date User Action Args
2021-05-09 08:17:00erlendaaslandsetrecipients: + erlendaasland, ghaering, elfring, zzzeek
2021-05-09 08:17:00erlendaaslandsetmessageid: <1620548220.41.0.153714200843.issue22956@roundup.psfhosted.org>
2021-05-09 08:17:00erlendaaslandlinkissue22956 messages
2021-05-09 08:17:00erlendaaslandcreate