openlp-core team mailing list archive
-
openlp-core team
-
Mailing list archive
-
Message #17729
[Bug 1068613] Re: caching sqlalchemy queries
Like the idea in principle
** Changed in: openlp
Importance: Undecided => Wishlist
--
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/1068613
Title:
caching sqlalchemy queries
Status in OpenLP - Worship Presentation Software:
New
Bug description:
Sqlite nor sqlalchemy does not provide any mechanism for caching data.
Everytime all sql queries are processed even when the same queries are
done several times.
We could improve the openlp performance in retrieving data from sqlite
database files with some caching mechanism.
Sqlalchemy provides some examples how to do that with Beaker
(http://pypi.python.org/pypi/Beaker/):
http://docs.sqlalchemy.org/en/rel_0_7/orm/examples.html#beaker-caching
Beaker is a pure-python library. It allows caching on filesystem and
even in memory only.
To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/1068613/+subscriptions
References