CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • CiviEvent Dashboard - Slow Load time
Pages: [1]

Author Topic: CiviEvent Dashboard - Slow Load time  (Read 1591 times)

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
CiviEvent Dashboard - Slow Load time
August 19, 2008, 09:13:04 am
Our CiviEvent dashboard takes over 4 minutes to load.  I am not sure why, but I have captured the queries that are being run before it loads. I can't upload the file of the queries - so I will link to it..... any help you all can provide would be great!

Here is a link to the query list that is causing the 4 min Event Dashboard load:

http://www.fpwr.org/sites/www.fpwr.org/files/FPWR-EventDashboard_SlowQuery.txt

Thanks

Jeff

Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: CiviEvent Dashboard - Slow Load time
August 19, 2008, 11:08:43 am
Jeff,

Which version of CiviCRM are you running? There has been at least two issues for 2.0 that were improving performance situation with CiviEvent dashboard: http://issues.civicrm.org/jira/browse/CRM-2735 and http://issues.civicrm.org/jira/browse/CRM-2972. Both fixes are available in 2.0.5, so make sure that you're running this version.

In the meanwhile, I'll try to look closer at the log.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviEvent Dashboard - Slow Load time
August 19, 2008, 11:33:09 am

as michal suggested, i'm hoping an upgrade to 2.0.5 will fix the issue

if not, can you please get on IRC and we can sort it out there. We'll need ssh access to your server, since this behavior is data dependent :(. Ideally i'd like to track and fix this today, since we are doing a 2.0.6 release tomorrow

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
Re: CiviEvent Dashboard - Slow Load time
August 19, 2008, 12:14:56 pm
Ok, I will install 2.0.5 (we are on 2.0.2) and see if that works


Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
Re: CiviEvent Dashboard - Slow Load time
August 19, 2008, 12:33:05 pm
Ok - upgraded to 2.0.5 - its fixed - thanks!

Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • CiviEvent Dashboard - Slow Load time

This forum was archived on 2017-11-26.