It load slowly if 10000 articles above

hi msn5158,

are you trying to load 10.000 articles at once in your page? if not, are you employing pagers?

from what you're saying, it looks like you need to leverage some form of caching strategy on your website.

if possible, could you please test with other Views display formats and report back?

thanks

Hello,

The website has over 10000 articles, a single page may not display many. However, the TARDIS module needs to load all the content to collect and display the years/months. If a portion of the content is loaded through filtering, it will display incomplete years and months, the months of publication of the filtered articles will not be displayed in TARDIS.

oh, I see. thanks for the update. I'll work on a solution.

hi msn5158,

I've implemented hook_views_query_alter() to make the queries leaner: they should now return one result per month, regardless of you DB being MySQL, Postgres, or SQLite.

could you please test and report back?

otherwise your DB might need to be optimized, but that would fall outside the scope of my module.

thanks