Views performance problem..
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.net>wrote:
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>
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/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd
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.net>wrote:
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/ ]
participants (4)
-
Earnie Boyd -
rajan kumar -
Steve Kessler -
Wipe_Out