Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

add cache on the filters values #270

Open
agallou opened this issue Mar 1, 2016 · 0 comments
Open

add cache on the filters values #270

agallou opened this issue Mar 1, 2016 · 0 comments
Assignees

Comments

@agallou
Copy link
Owner

agallou commented Mar 1, 2016

The request to get the mainteners list is sometimes slow :

SELECT package.maintainer FROM `package` GROUP BY package.maintainer ORDER BY package.maintainer ASC

https://github.com/agallou/mageia-app-db/blob/master/lib/filtering/filters/maintCriteriaFilter.class.php#L10

@stormi we may need to add a maintainers table

In the meantime, we could add cache on the filters value (there is cache on the filters components but it depends on the url parameters). Cache it on a redis/memcached.

This cache should be invalided after each synchronization.

@agallou agallou self-assigned this Mar 1, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant