Lafcadio 0.7.0: Excessively Clever Query Caching
Lafcadio 0.7.0, the new development release, is out. It adds my first try at Excessively Clever Query Caching.
Excessively Clever Query Caching goes like this: Everytime you run a select against the DB, Lafcadio caches the results in memory. Then, if you later run a second select that is a subset of the first, Lafcadio detects it, figures out what it’s a subset of, filters out the results in memory, and returns you the results. This all happens transparently.
What does this mean? It means a significantly faster app, because if you run these three queries:
select * from users where lname = 'Smith' select * from users where lname = 'Smith' and fname like '%john%' select * from users where lname = 'Smith' and email like '%hotmail%'
Lafcadio will only ask MySQL for the results for the first select statement, and do the rest for you without using the DB connection.