By luigi-1 on

I run a drupal installation on a host with PHP5 and MySQL. The performance is terribly slow. I first thought it had to do with the host, but more likely it has something to do with either the Drupal installation or the database, or the combination between the two.

I *know* that Drupal is not yet PHP5 compatible / compliant, but, hey, I discovered only after buying the hosting that my host runs PHP5 -- so if possible I would like to tweak Drupal, instead of changing to another host.

my site:
http://www.religionresearch.org

Comments

killes@www.drop.org’s picture

killes@www.drop.org commented

Drupal has some subtle problems on php5 but being slow is none of them. I suspect yout php/mysql config couldbe better.
--
If you have troubles with a particular contrib project, please consider filing a support request. Thanks. And, by the way, Drupal 4.5 does not work with PHP 5.

--
Drupal services
My Drupal services

luigi-1’s picture

luigi-1 commented

it's off topic, so don't comment on it if you're busy, but if you have ideas what could cause it, i would like to know.

jsbthree’s picture

jsbthree commented

There should be a sections or FAQ specifcally for this very narrow topic -- database optimization or what can cause general slowness. Its very hard to pinpoint in specific installations and there has to be alot of factors taken into account. too many in fact for this kind of probelm to be worked out in a forum really.

What should be here is a general laundry list of possibilities that the site builder/webmaster / developer can read and see which apply to their specific situaton. Anything else tends to be alot of random stabbing in the dark.

An example is the case of too many blocks. Often this is just overlooked. The developers assume this knowledge howerver even very advanced users and non drupal developers can overlook this as building a site is not an everyday activity so some of the stuff is easily forgotten.

So too many blocks .. what else? Anyone have an example? This can be the start of such a list.

piou’s picture

piou commented

It was taking 25+ seconds for me to pull up the aggregator administration screen; sped this up considerably by adding an index to the aggregator_item table:

alter table aggregator_item add index (fid);

I'd think such things would be in the default setup; guess not.

http://www.piou.org/

micha_1977’s picture

micha_1977 commented

What you mean by saying its "slow" ?

I clicked on your site-link and the first article...it did go fast

anyways

i had some similar speed problems, but there were located in the rewrite rules, not of drupal itself but some host-selfmade-internal-rewrites, especially made for php5 / php4 Support

-micha
work in progress with Drupal 4.6: langmi.de

jsbthree’s picture

jsbthree commented

But that it happens. So to be helpful to other users and developers we can have a fairly comprehensive list of the possible causes. I'm not interested in pointing fingers and apportioning sending comments off to respective modules or other sites like maybe the Apache foundation. This is anm example of where even vague possible reasons can be helpful in triggering ideas in the reader.

For example your comments are very helpful to me on another issue with perfomance I was trying to work out.