Please check this URL: <a href="http://drupal.org/node/1608276%20">http://drupal.org/node/1608276 </a><br><br><br><br><br><div class="gmail_quote">On Sat, Jul 21, 2012 at 3:33 AM, Wipe_Out <span dir="ltr"><<a href="mailto:wipe_out@users.sourceforge.net" target="_blank">wipe_out@users.sourceforge.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<div><br></div><div>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.</div>
<div><br></div><div><span style="line-height:18px;color:rgb(34,34,34);font-size:13px;font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif">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..</span></div>
<div><span style="line-height:18px;color:rgb(34,34,34);font-size:13px;font-family:'Lucida Grande','DejaVu Sans','Bitstream Vera Sans',Verdana,Arial,sans-serif"><br>
</span></div><div><font color="#222222" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif"><span style="line-height:18px">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..</span></font></div>
<div><font color="#222222" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif"><span style="line-height:18px"><br></span></font></div><div><font color="#222222" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif"><span style="line-height:18px">Anyone have any ideas??</span></font></div>
<div><font color="#222222" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif"><span style="line-height:18px"><br></span></font></div><div><font color="#222222" face="Lucida Grande, DejaVu Sans, Bitstream Vera Sans, Verdana, Arial, sans-serif"><span style="line-height:18px">Thanks..</span></font></div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br><br clear="all"><br>-- <br>Thanks,<br>Rajendra Kumar Thakur<br>9313055271<br>Skype:- raj_php<br>
<a href="http://www.paridhansoft.com" target="_blank"></a><br>