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 <rep...@bugs.python.org>
<http://bugs.python.org/issue15764>
_______________________________________
_______________________________________________
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

Reply via email to