Sqlite3 performance

[jhlj]

BPO	15764
Nosy	@loewis, @vstinner
Superseder	bpo-9303: Migrate sqlite3 module to _v2 API to enhance performance
Files	db-test.py

^{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 2012-08-22.14:57:49.453>
created_at = <Date 2012-08-22.12:51:11.775>
labels = ['extension-modules', 'performance']
title = 'Sqlite3 performance'
updated_at = <Date 2012-08-22.14:57:49.451>
user = 'https://bugs.python.org/jhlj'

bugs.python.org fields:

activity = <Date 2012-08-22.14:57:49.451>
actor = 'loewis'
assignee = 'none'
closed = True
closed_date = <Date 2012-08-22.14:57:49.453>
closer = 'loewis'
components = ['Extension Modules']
creation = <Date 2012-08-22.12:51:11.775>
creator = 'jhlj'
dependencies = []
files = ['26964']
hgrepos = []
issue_num = 15764
keywords = []
message_count = 3.0
messages = ['168881', '168886', '168890']
nosy_count = 3.0
nosy_names = ['loewis', 'vstinner', 'jhlj']
pr_nums = []
priority = 'normal'
resolution = 'duplicate'
stage = None
status = 'closed'
superseder = '9303'
type = 'performance'
url = 'https://bugs.python.org/issue15764'
versions = ['Python 3.4']

[jhlj]

The _sqlite modules uses sqlite3_prepare and not sqlite3_prepare_v2.
With sqlite3_prepare_v2 enables more optiomation.

Workaround:
Do not use parameters as the right hand argument to GLOB or LIKE.

For more documentation see http://www.sqlite.org/optoverview.html.

[vstinner]

Such change cannot be done in a version older than Python 3.4 (older versions only accept bugfixes, this is an improvment).

[loewis]

This is a duplicate of bpo-9303