[issue15764] Sqlite3 performance

2012-08-22 Thread Martin v . Löwis
Martin v. Löwis added the comment: This is a duplicate of #9303 -- nosy: +loewis resolution: -> duplicate status: open -> closed superseder: -> Migrate sqlite3 module to _v2 API to enhance performance ___ Python tracker

[issue15764] Sqlite3 performance

2012-08-22 Thread STINNER Victor
STINNER Victor added the comment: Such change cannot be done in a version older than Python 3.4 (older versions only accept bugfixes, this is an improvment). -- nosy: +haypo versions: -Python 2.6, Python 2.7, Python 3.1, Python 3.2, Python 3.3 ___ P

[issue15764] Sqlite3 performance

2012-08-22 Thread 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/