Repository navigation
[sqlite3] speed up cursor.execute*() #90792
Description
| BPO | 46634 |
|---|---|
| Nosy | @erlend-aasland |
| PRs | Connection.cursor() in sqlite3 #31127 |
Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.
Show more details
GitHub fields:
assignee = None
closed_at = <Date 2022-02-17.08:26:39.839>
created_at = <Date 2022-02-04.10:38:53.668>
labels = ['extension-modules', '3.11']
title = '[sqlite3]\xc2\xa0speed up cursor.execute*()'
updated_at = <Date 2022-02-17.08:26:39.838>
user = 'https://github.com/erlend-aasland'bugs.python.org fields:
activity = <Date 2022-02-17.08:26:39.838>
actor = 'erlendaasland'
assignee = 'none'
closed = True
closed_date = <Date 2022-02-17.08:26:39.839>
closer = 'erlendaasland'
components = ['Extension Modules']
creation = <Date 2022-02-04.10:38:53.668>
creator = 'erlendaasland'
dependencies = []
files = []
hgrepos = []
issue_num = 46634
keywords = ['patch']
message_count = 2.0
messages = ['412503', '413390']
nosy_count = 1.0
nosy_names = ['erlendaasland']
pr_nums = ['31127']
priority = 'normal'
resolution = 'fixed'
stage = 'resolved'
status = 'closed'
superseder = None
type = None
url = 'https://bugs.python.org/issue46634'
versions = ['Python 3.11']
Activity
erlend-aasland commentedon Feb 4, 2022
pysqlite_connection_execute_impl()and friends (executemany, executescript) goes all the way through the Call API just to callpysqlite_connection_cursor_impl. We can same a lot of calls by calling the cursor _impl function directly; after all, it does live in the same file scope as the callers.A quick bench (sqlitesynth) shows a small speedup:
(Side effect: will get rid of _Py_IDENTIFIER(cursor) in sqlite3)
erlend-aasland commentedon Feb 17, 2022
The change proposed in #75310 was included in #75532. Closing this.