hi all,
i am new to drupal CMS .
i 'm searching for a news cms to setup an internet news site for my office .
after searching in google and trying out some open-source cms finally i choosed Drupal .
but after installing Drupal6.2 i am not sure to countinue with it .

it is really slow !

just after installing it i though maybe the problem is my server with debian distributaion is running on it but after installing Drupal5.7 now i am sure there are some problems with the 6.2 ones.

now i am here to ask you if you have the same problem with 6.2 version or not ?
and that is the problem ? adding Ajax to it ?

thanks a lot new friends .

Comments

jeetn’s picture

We have the same problem. We have absolutely no clue how to solve it :s

We are running PHP 5.2 on IIS 5.1 or 6.0.

The site itself works perfectly fine, but the administrator module takes 15 seconds to move to the next link!!

Also a module can't be added. We can add it and click save, but then the entire administer stuff shows white (blanc) pages... Nothing we can do... Only solution is too delete module from the directory...

Magnity’s picture

Try adding a php.ini file to the root folder of your installation, with the line:
memory_limit = 256M

If that works, you might even be able to increase it further depending on the spec of your server. This is commonly a problem when being hosted on virtual servers, as the host sets the default very low.

If it doesn't work... let us know and we'll have another think...

Magnity

http://webdesign.magnity.co.uk
Magnity Webdesign is currently looking to recruit developers for a number of client projects.

jeetn’s picture

Hi,

I went to my php root folder (C:\PHP). Opened php.ini and changed the memory_limit too 256MB and too 512MB.

max_execution_time = 30     ; Maximum execution time of each script, in seconds
max_input_time = 60	; Maximum amount of time each script may spend parsing request data
;max_input_nesting_level = 64 ; Maximum input variable nesting level
memory_limit = 512M      ; Maximum amount of memory a script may consume (128MB)

Had absolutely no effect :s

abhilasha bhardwaj’s picture

also unable to access any content say page of my website now!!!!!!!!
please somebody help me!!!!!!!!!!!!!!!

drupalnesia’s picture

i experience same issue, caused by nodeaccess module forgot to install in the new site.
after install again nodeaccess and do Rebuild Access then I can access the content.

Also slow performance when Save any edited content, look like I missing some module. try to install again Taxonomy-Menu module.
Please check any in previous site (D5) should be install again in D6.

Wayne_Luke’s picture

I had this problem when trying to use the Contemplate module. When I deleted it from my modules, then I could lower the memory requirement and load additional modules. There is an issue about memory and I don't know if it has been fixed or not.

The problem that I found with Drupal 6 is that it runs thousands of queries on the Modules page. Looking at the queries it run, it appears to rebuild the menus for every single module in the system on every page load in a loop. It doesn't cache this information, well it does but rebuilds it on every page load. The issue got to be so much that I abandoned 2 months of work and started over with Drupal 5. Now I have more modules installed and am using less queries per page load and have a more responsive development site. In Drupal 6, it would take 50 seconds to load the module page and generated 5000 queries. In Drupal 5, it takes 6 seconds and there 169 queries. And I have three times as many modules installed.

Front end pages are more responsive as well. Well at least with Drupal 5.7, I can use vBulletin for the forum and integrate the login and registrations of the two products.

abhilasha bhardwaj’s picture

exactly same problem but i m running it on apache.
it is working nicely but from today .......

abhilasha bhardwaj’s picture

i think the problem is this as my ststus report says
HTTP request status Fails
Your system or network configuration does not allow Drupal to access web pages, resulting in reduced functionality. This could be due to your webserver configuration or PHP settings, and should be resolved in order to download information about available updates, fetch aggregator feeds, sign in via OpenID, or use other network-dependent services.

Magnity’s picture

Right, we've got a number of people posting there - are you all having the same problem?

Firstly, for those getting blank pages after changing php.ini, are you getting the functionality back if you reverse the change? Is there a compromise number that works?

Secondly, the module issues: are you using the throttle module? If so have you throttled any of the core tasks?

For those having problems, please can you provide a bit more info as to what you've tried and the effect its had - also about the state of your installation (how new, when did you first get the issues).

Magnity

http://webdesign.magnity.co.uk
Magnity Webdesign is currently looking to recruit developers for a number of client projects.

jeetn’s picture

Hi,

Thanks for the help but we've changed to Drupal 5.7. The speed is amazing now!! In comparison with 6.2 the difference is huge.

So my speed problem is solved and the module problem is solved.

But to answer your question:

I added the modules here in this directory: drupal\sites\all\modules\"modulefolder"

The next step was to read the install.txt file inside that folder, mostly it told the same. Go to Administer -> site building -> modules

I did so, scrolled to the bottom, clicked the module added in the directory, saved configuration and there you got the blank page.

The blank page is in FF.
In IE you get a message which tells you that the page cannot be loaded.

To resolve the issue I deleted the folder in the modules directory and I could administer Drupal again.

Wayne_Luke’s picture

My experience as well. Drupal 6 isn't ready for primetime until it has some serious query optimization... 2000-3000 queries on a page load is not practical, most of that is rebuilding caches that were built on each of the prior page loads. Why have them if they aren't going to be used in anyway?

Magnity’s picture

Just to separate the comments out for each of you:

cmsfinder: have you tried the new settings? i think the php.ini solution will work for you.
jeetn: see second bit of prev post.
abhilasha: it is very confusing as i think your problem is totally different to the ones on this thread. You're going to need to provide extra info about what has changed today.

Guys, please keep specific: i think we have 3 different problems here, so its very confusing having them all in one thread.

Magnity

http://webdesign.magnity.co.uk
Magnity Webdesign is currently looking to recruit developers for a number of client projects.

abhilasha bhardwaj’s picture

my problem is that my drupal (ver 6.2) is running very slow as compared to the previous days.
i also changed my php.ini but nothing happens.
i am using apache2.2 , PHP, MySql
and also, today i am unable to access my content pages.
should i start another forum topic for this problem???
also i ma unable to run cron.php now

Magnity’s picture

Are you running on your own server, or hosted?

Magnity

http://webdesign.magnity.co.uk
Magnity Webdesign is currently looking to recruit developers for a number of client projects.

abhilasha bhardwaj’s picture

yes it is, i m running it on my machine

abhilasha bhardwaj’s picture

i think that my problem is different because i can access other areas of my site at right speed .
my problem is i am unable to access some parts of my site including front page....
please help meeeeeeee

abhilasha bhardwaj’s picture

i got my problem's solution through one of my friend......
i have created "the redirected to URL" enabled in triggers.
that is the cause of my problem.
thanks to all

shijina’s picture

Try it again by disabling "Update Status" module.

shijina’s picture

Try it again by disabling "Update Status" module.

gunes_t’s picture

Hi i have nearly the same experience with the 6.2 installation. I try several combinations:

- use vmaware host: vistasp1 guestst: ubuntu 7.10 lamp php5.2 mysql 5.1, apache2
- WAMPserver 2.0c local insallation
- Xamp lates buil local installation.
- WAMP on a remote windows 2003 server

In all casess drupal runs extramly slow. Some cases no response at all.

On the same configuration, i install 5.7 without changing other parameter, it runs very fast. After 2week i give up up and go back to my 5.7 version.

Sory i have no more log files, but if need i can just install wamp and drupal and provide the more detail information, just let me know what you want.

jasom’s picture

i have same problem as you

Win XP
Wamp server 2.0c
Drupal 6.2

-------------------
after opening admin pages localhost/drupal-6.2/?q=admin of the fresh new inslated drupal 6.2 (and wamp server too) I see just blank page (white screen) (Opera, FF and IE7). There is no souce code.
-------------------

What I should to do?

greg911’s picture

I can access some of the pages from the Administer block by entering their complete adress (mysite.com/admin/content/) for example. I've tried to disable the cleanURL and it wont work.
Got the same setup as Jasom :
XP
Wamp Sever 2.0c
Drupal 6.2

However, it works beautifully with 5.7
Is there any chance there's a fix ?

------------------ FIXED --------------------------
My problem was : By default, Drupal 6.x enables updates on a new install
However, I'm behind a proxy so it makes the module fail to retrieve updates.
To solve it, I went to www.mysite.com/admin/content and then, I saw the administer tree. Navigate to the Module page, disabled and uninstalled the Update module and everything works great. I found a workaround for the proxy while searching but it was for Drupal 4.x
----------------------------------------------------

otosi’s picture

Greg911 - You're the man! You saved the day.

I had a development drupal site that worked great. When we moved the database and files, however, the admin slowed to a crawl. It took nearly a minute between page loads. As soon as I read your post, I disabled the Update Module and the problem resolved.

Naturally, we are going to correct the issue so we can re-enable the Update Module, but I just wanted to say THANKS for your FIXED comment. Saved us a lot of headache.

Otosi

EyeChartBrew’s picture

Tks to greg911 for finding this fix -- I sooooo did not want to regress back to Drupal 5.x for this issue!
Cheers!
//TB

rsantiag’s picture

By the moment, disabling Update module, all the CMS works faster than before...

wildthing4ever’s picture

I had just figured out that updates might be the problem, since I was running behind a proxy, and noticed that there were massive amounts of errors in the logs saying that updates had failed. Disabling and uninstalling the update module has done the job.

Thanks!

snorkers’s picture

Really no idea why everything is just so slow running Drupal 6.5 on WAMP 2 and Vista as a local development environment.
Following everyone's advice I've:

  • Increased PHP memory limit to 1GB
  • Completely fresh install of Drupal
  • New MySQL database
  • Uninstalled Update status module

But it's still achingly slow on Wampserver which is a pain as it should be great for development. Comparable Drupal installation (same modules etc) running on a Mac local installation - fine; running on a remote Win2003 server (no WAMP, but manually configured AMP) - fine. So really stuck with this crippling performance problem.

Any other 'top tips' gratefully received

keesje’s picture

Mac v.s. Windows: you probably use MAMP on Mac?
I too noticed a very significant speed difference between MAMP on OSX and WAMP on XP (same HW). But this is not bound to Drupal.
Please note that MAMP has PHPcaching methods installed/enabled by default where WAMP has not, this only partially explains the performance difference, MYSQL seems to be a lot snappier in responses too.

So, Mac+MAMP wins on this terrain with a huge leap.

Elita-1’s picture

but drupal 6.2 is faster for me !!!

http://forum.pcgames.ir

Marc Hoefman’s picture

I am having a performance problem that does not seem to relate to any of the points mentioned before:

I'm running Drupal 6.3 on Bluehost and the access to the website runs quite well with Firefox.

The long time it takes to load and render pages with Internet Explorer 6 is unacceptible. So not just with Admin pages but all page access suffer from that. I did not check if IE7 is different from IE6.

Putting all Drupal performance possibilities (cache, ...) into action does not help a lot.
I also increased the PHP memory from 32M to 64M without any result.

This behaviour I never saw with Drupal 5.x!

What could be the reason for IE6 behaving like this?

Marc

hexag’s picture

hey guys,

my setup... WAMP...
Apache Version :
2.2.8
PHP Version :
5.2.6
MySQL Version :
5.0.51b

Increased PHP memory to 256, disabled updates, but it still takes over a minute to update the modules page (everything else seems swift enough, but still a bit slow for a local machine), it almost's got to the start here I can have a quick gander at reddit when I install a module! Getting slower with the growth of the site & it's something which's going to drive me balmy with it getting bigger!

cheers,

Nick,

termi’s picture

Windows/XP
Apache Version :
2.2.10
PHP Version :
5.2.6
MySQL Version :
5.0

Found out the reason why MY system was running slowly.. Or more precisely the Admin pages where loading really slowly (modules page, report page and the rest.). Took something like 30-50sec to load. Front page loaded normally (fast).

And the reason was... Firewall which prevented some Apache accesses.

So one hint among other is to check that all the SW involved (PHP, MySQL etc.) have the access with firewalls (I used Kerio).

keesje’s picture

I recently ditched XP as dev AMP OS, I run LAMP within VMware in VMplayer on XP. Really, a Lamp VMsession with 512K of memory on XP as a host runs Drupal loads faster than all Xampp/Wamp/Whaterveramp installed on XP or Vista with 3G of memory in my experience.
To ease filetransfers you can use Samba.
If you can't/wont build a VM yourself, search for "lamp" in the Virtual Appliance Marketplace: http://www.vmware.com/appliances/, there are plenty of 'em around.

xacto’s picture

I spent days searching and trying to figure out why drupal was running so slow on Mamp all of the sudden.
I didn't realize when I reinstalled my MAMP server I lost the mysql my.cfg settings.
Please double check and setup you my.cfg file correctly.

Setting the my.cfg file by duplicating "my-huge.cfg" to "my.cfg" did the trick.

Please check out this link to help instruct you on the process.
http://drupal.org/node/51263

Hope this helps someone!!!

It did for me.
;-)

Guido Forks’s picture

Changing the MySql table type from InnoDB to MyISAM made a massive difference to me. I wrote a little script to automate changing the table types for other Drupal DBs I've got:

$dbAddress = "localhost";
$dbUser = "mysql_username";							 		 			 			
$dbPass = "mysql_password";
$dbName = "db_name";

print('DATABASE = '.$dbName.'<br />');

function queryDb($sqlStr)
{
	mysql_connect($GLOBALS["dbAddress"], $GLOBALS["dbUser"], $GLOBALS["dbPass"]) or die('Error: Cannot connect to database');
	mysql_select_db($GLOBALS["dbName"]) or die('Error: Cannot select database');
	if($result = mysql_query($sqlStr))
		return $result;
	else
	{
		print('Query failed: '.mysql_error());
		print('<pre>'.$sqlStr.'</pre>');
		die();
	}
}

if($result = queryDb("
	SELECT TABLE_NAME, ENGINE
  	FROM information_schema.TABLES
  	WHERE TABLE_SCHEMA = '$dbName'
"))
{
	while($row = mysql_fetch_assoc($result))
	{
		print('TABLE_NAME = '.$row['TABLE_NAME'].', ENGINE = '.$row['ENGINE'].'<br />');
		//queryDb("ALTER TABLE ".$row['TABLE_NAME']." ENGINE = InnoDB");
	}	
}

Just setup the username, password and db name at the top, check the output and then uncomment the call do queryDb() in the while loop when ready.