Deal all

I've been stucking on this issue for a few days so I decided to present it here and hope for a precious help from our community.

I'm almost done of intergrating fullcalendar into my website but the loading time. I have about 200 events and geting even more which are repeated daily, weekly, monthly... many kinds of repeating events. It's impossible to load all these events initially since it requires tons of queries and got time-out error from apache, cannot be cached either.

What I want to do for improving it is init the fullcalendar view in day-view mode, then just fetch the events in the next 7 days, disable the completed events. Take a look at the date field table, I saw one repeating event will be divided into entites that have their own start and end date for each day, so guess it's possible to filter them out by a view date filter.

db

I added view filter as the attached image. Output query is correct.

filter

But the result just remained the same: displayed the events in the past and in the far future.

result

I already tested this filter with an ordinary view and get the expected results. So I'm kinda sure the issue only comes from the module code, for some reasons it doesn't apply the filter. I have been speeding several days on examining the code but didn't have any luck yet. Anyone experienced this or has a better idea to improve the loading time please leave some words. I'd appreciate any time consuming on this topic.

You can view my full view at. http://citypassguide.com/vietnam-deals.

Thanks again.

Support from Acquia helps fund testing for Drupal Acquia logo