search

coleifer / pysqlite3

SQLite3 DB-API 2.0 driver from Python 3, packaged separately, with improvements
zlib License
183 stars 51 forks source link

SQL compilation caching #35

Closed AbdealiLoKo closed 2 years ago

AbdealiLoKo commented 2 years ago

I get this error when I try to use pysqlite3

Dialect sqlite:pysqlite will not make use of SQL compilation caching as it does not set the 'supports_statement_cache' attribute to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Dialect maintainers should seek to set this attribute to True after appropriate development and testing for SQLAlchemy 1.4 caching support. Alternatively, this attribute may be set to False which will disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)

coleifer commented 2 years ago

Looks like it should support it, I'd take it up with sqlalchemy maintainers.

https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalchemy/dialects/sqlite/pysqlite.py#L445-L447