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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Website extremely slow
Pages: [1]

Author Topic: Website extremely slow  (Read 3067 times)

Geoffrey

  • Guest
Website extremely slow
November 16, 2010, 02:57:54 am
Hello,

I use an ESX 4.0 VM with 2 virtual CPU's and 2GB RAM only to host my CiviCRM website, but it's still extremely slow!!

What could cause this slowleyness?

Thanks for any advice!

 :)

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Website extremely slow
November 16, 2010, 07:50:46 am
Can you be more specific, all your CiviCRM pages are slow?
Is your drupal working fine.

Kurund
Found this reply helpful? Support CiviCRM

Geoffrey

  • Guest
Re: Website extremely slow
November 16, 2010, 11:46:51 pm
It's civiCRM that works slow. The only module activated is civiCase. My drupal site itself works fast enough (but not superfast). All other modules are disabled in drupal.

It takes a long time to open a contact, to start a new case or activity, it even takes a long time to open the startpage!

Yesterday I have enabled .js and .css compression and that makes it a little faster already (but not fast enough).

I also optimized the mysql tables and tried to restart the server several times, but without success. I checked the log-files (apache and php logs), but there's nothing remarkable to see.

When I just had installed civiCRM it did work very fast!! I just don't know what happened...

Thanks for any help!!

 :)

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Website extremely slow
November 17, 2010, 12:52:25 am
Can you check if you css and js is loading properly. Make sure you have correct resource url etc.

Kurund
Found this reply helpful? Support CiviCRM

Geoffrey

  • Guest
Re: Website extremely slow
November 17, 2010, 01:51:16 am
I have used the firefox Error-console to check and I get no errors. Just a lot of CSS warnings, but no errors at all.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Website extremely slow
November 17, 2010, 01:58:28 am
Can you jump on #civicrm irc ( http://webchat.freenode.net/?channels=#civicrm )

might be easier..

Kurund
Found this reply helpful? Support CiviCRM

Geoffrey

  • Guest
Re: Website extremely slow
November 22, 2010, 07:38:26 am
Hello,

The link you provided doesn't work for me... I only see a blank page.

What I already did:

Activated compression in drupal
Activated PHP cache en optimizing with xcache
Enabled Mysql query caching
Activated memcached, but did made my website not working as it should, so I deactivated it again.

The website works a bit faster now, but still way too slow! It's just not normal as civicrm is the only website running on the entire server.

Does anybody has some idea how I could improve the speed of my civicrm website?

Thanks!!!

 :)

staze

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
    • staze.org
  • CiviCRM version: 4.0.4
  • CMS version: Drupal 7
  • MySQL version: 5.0.67
  • PHP version: 5.2.9
Re: Website extremely slow
December 14, 2010, 10:33:41 am
I'm seeing the same thing after enabling CiviCRM (CiviEvent).

The underlying filesystem is a SAN, and it looks like after enabling CiviCRM, Drupal is doing a getattr on every file in the CiviCRM module any time I access any of the CiviCRM pages (god knows why), which since there are about 5500 files in the module directory, it slows everything down quite a bit.

This might be drupal causing this, but it showed up really only after installing CiviCRM.

Any ideas? Right now, the CiviCRM stuff is neigh unusable.

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: Website extremely slow
December 14, 2010, 11:14:42 am

have u tried using a PHP opcode cache

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

staze

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
    • staze.org
  • CiviCRM version: 4.0.4
  • CMS version: Drupal 7
  • MySQL version: 5.0.67
  • PHP version: 5.2.9
Re: Website extremely slow
December 14, 2010, 12:17:10 pm
Yes, I am using an opcode cache... APC (3.0.19) to be specific.

This seems to be drilling through all the directories, for what reason, I don't know.

I'd almost wonder if drupal_get_filename() was being called for some reason...

I'd attach a zip file of the output for "fs_usage http | grep drupal" but I can't attach zips, and uncompressed, the file is almost 1MB. But, in about 10 seconds (which is how long it took the page to load), it hit about 7000 files. All "getattrlist". So for some reason, it's checking permissions, file size, etc.

I just tried disabling APC, and had the same result. Also toggled apc.stat and that also didn't change the result.

Any other ideas? It would be nice to see what is actually stating all the files... I'm guessing this has always happened in drupal, but CiviCRM just made it worse since it has SO many files.

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: Website extremely slow
December 14, 2010, 02:18:48 pm

1. might want to put a debug in the directory traversal code (of drupal) and see if that is called and if so by whom.

2. Does this happen on ALL drupal pages or just a couple? What about CiviCRM pages?

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

staze

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
    • staze.org
  • CiviCRM version: 4.0.4
  • CMS version: Drupal 7
  • MySQL version: 5.0.67
  • PHP version: 5.2.9
Re: Website extremely slow
December 14, 2010, 02:45:46 pm
CiviCRM pages are the worst. It seems to do it for all other pages, but it doesn't have to transverse nearly as many directories if it's something other than CiviCRM.

I'm not sure how I'd debug the directory transversal code. For now I'm going to have to backburner this while I figure out how to get Views working with CiviCRM in a separate database. =/

qjensen

  • I post frequently
  • ***
  • Posts: 141
  • Karma: 11
    • Scaled Solutions
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Website extremely slow
December 16, 2010, 09:05:40 am
While doing some research on performance issues for one of my sites, I found this article that talks about the realcache setting in php.ini. I made the changes, restarted apache and have seen some improvement. I don't know what the equivalent of fs_usage is on Linux so I don't have hard data to compare. I would be interested to hear if anyone else has modified the realpath setting in the php.ini file and seen performance improvements.
Quint Jensen
Web Developer
Scaled Solutions
--" Remove the 'I want you to like me' notes from your forehead and place them where they truly will do the most good -- on your mirror!" Author Unknown
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Website extremely slow

This forum was archived on 2017-11-26.