Hi,
I have an events calendar (Full Calendar) that hat to display a large number of events (0 - 40+ each day, 500-1000 on a month).. On my development server I have loaded three months worth of events (~1500 events) and the view is taking 17-25 seconds to load.. This is not good and by the time there are two years worth of events on the system its will be ridiculous.
According to views the Query build time is 19.68 ms and the Query execute time is 3.5 ms so that suggests its not a problem with the database but something with the way Drupal is rendering the content..
The other issue is all the users accessing this information are authenticated and the view presented is user specific making any traditional caching, either globally or within views, ineffective..
Anyone have any ideas??
Thanks..
Please check this URL: http://drupal.org/node/1608276 http://drupal.org/node/1608276%20
On Sat, Jul 21, 2012 at 3:33 AM, Wipe_Out wipe_out@users.sourceforge.netwrote:
Hi,
I have an events calendar (Full Calendar) that hat to display a large number of events (0 - 40+ each day, 500-1000 on a month).. On my development server I have loaded three months worth of events (~1500 events) and the view is taking 17-25 seconds to load.. This is not good and by the time there are two years worth of events on the system its will be ridiculous.
According to views the Query build time is 19.68 ms and the Query execute time is 3.5 ms so that suggests its not a problem with the database but something with the way Drupal is rendering the content..
The other issue is all the users accessing this information are authenticated and the view presented is user specific making any traditional caching, either globally or within views, ineffective..
Anyone have any ideas??
Thanks..
-- [ Drupal support list | http://lists.drupal.org/ ]
On 21 July 2012 17:05, rajan kumar rajenthakur.kumar@gmail.com wrote:
Please check this URL: http://drupal.org/node/1608276 http://drupal.org/node/1608276%20
The link doesn't appear to work.. Can you repost it please?
It had an extra space in it. Try removing the %20 part at the end.
http://drupal.org/node/1608276
On Sat, Jul 21, 2012 at 5:38 PM, Wipe_Out wipe_out@users.sourceforge.net wrote:
On 21 July 2012 17:05, rajan kumar rajenthakur.kumar@gmail.com wrote:
Please check this URL: http://drupal.org/node/1608276
The link doesn't appear to work.. Can you repost it please?
-- [ Drupal support list | http://lists.drupal.org/ ]
http://drupal.org/node/1608276 On Jul 21, 2012 10:05 AM, "rajan kumar" rajenthakur.kumar@gmail.com wrote:
Please check this URL: http://drupal.org/node/1608276 http://drupal.org/node/1608276%20
On Sat, Jul 21, 2012 at 3:33 AM, Wipe_Out wipe_out@users.sourceforge.netwrote:
Hi,
I have an events calendar (Full Calendar) that hat to display a large number of events (0 - 40+ each day, 500-1000 on a month).. On my development server I have loaded three months worth of events (~1500 events) and the view is taking 17-25 seconds to load.. This is not good and by the time there are two years worth of events on the system its will be ridiculous.
According to views the Query build time is 19.68 ms and the Query execute time is 3.5 ms so that suggests its not a problem with the database but something with the way Drupal is rendering the content..
The other issue is all the users accessing this information are authenticated and the view presented is user specific making any traditional caching, either globally or within views, ineffective..
Anyone have any ideas??
Thanks..
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Thanks, Rajendra Kumar Thakur 9313055271 Skype:- raj_php http://www.paridhansoft.com
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Earnie Boyd -
rajan kumar -
Steve Kessler -
Wipe_Out