[issue30271] Make sqlite3 statement cache optional

Aviv Palivoda added the comment: I think we can close this issue and open a different one that will disable the cache implicitly on `set_authorizer()`. -- stage: patch review -> resolved status: open -> closed ___ Python tracker

[issue30271] Make sqlite3 statement cache optional

Change by Berker Peksag : -- resolution: -> rejected ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: https:/

[issue30271] Make sqlite3 statement cache optional

Raymond Hettinger added the comment: > I do believe we should allow the user to disable the cache. Why? -- nosy: +rhettinger ___ Python tracker ___ __

[issue30271] Make sqlite3 statement cache optional

Berker Peksag added the comment: I'd prefer disabling statement cache implicitly when set_authorizer() is called. There's no need to expose this to end users. -- ___ Python tracker _

[issue30271] Make sqlite3 statement cache optional

Aviv Palivoda added the comment: I don't have any specific use case for making the statement cache optional. I expected that by changing the cache size to 0 there will be no statement cache. I think that this is a common assumption as can be seen in https://github.com/ghaering/pysqlite/issue

[issue30271] Make sqlite3 statement cache optional

Berker Peksag added the comment: Thanks for the report. What is your use case for making the statement caching optional? Did you notice any performance improvement when you use it with newer SQLite versions? -- stage: -> patch review versions: +Python 3.8 -Python 3.7 __

[issue30271] Make sqlite3 statement cache optional

Changes by Aviv Palivoda : -- pull_requests: +1560 ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: https://mail

[issue30271] Make sqlite3 statement cache optional

New submission from Aviv Palivoda: Currently the minimum size of the statement cache is 10. I suggest that it will be any value above 1 or no cache at all if the size is set to 0. -- components: Extension Modules messages: 293006 nosy: berker.peksag, ghaering, palaviv priority: normal s