[New-bugs-announce] [issue15764] Sqlite3 performance

[Jens Henrik Leonhard Jensen]

New submission from Jens Henrik Leonhard Jensen:

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.

----------
components: Extension Modules
files: db-test.py
messages: 168881
nosy: jhlj
priority: normal
severity: normal
status: open
title: Sqlite3 performance
type: performance
versions: Python 2.6, Python 2.7, Python 3.1, Python 3.2, Python 3.3, Python 3.4
Added file: http://bugs.python.org/file26964/db-test.py

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue15764>
_______________________________________