Very slow drupal 7 site

By wer0ckz on 7 Nov 2014 at 05:07 UTC

Hi Guys.

Please help. I just started with drupal and created few views and taxonomy and it's very slow.

Please see my drupal 7 site: http://192.3.159.224/

It took 13-15 seconds to load the first page on the first time.

Under performances:

I checked:

- Cache pages for anonymous users
- Cache blocks
- Compress cached pages.
- Aggregate and compress CSS files.
- Aggregate JavaScript files

Here are the list of all modules: http://pastebin.com/8af08PKj
Here are t he list of modules ENABLED: http://pastebin.com/DB8DzQs5

Is it the host that I'm using?
Is it too many pictures?

Can you please share the methods how to optimize the speed of your drupal?

Thanks in advanced!

Comments

when I had faced same issue

Amruta_dani commented 7 November 2014 at 08:51

when I had faced same issue with our website I had run update.php (hhtp://urwebsitee.com/update.php) that solved my problem check once with this option please make sure you keep backup of data nad database before run update.php

Drupal developer

Still the same.

wer0ckz commented 7 November 2014 at 13:18

Hi. Thanks for your reply.

I tried update.php and still no changes.

The site is very slow to

gooney0 commented 9 November 2014 at 07:34

The site is very slow to respond even on pages with few images (such as /user)

This could be many things.

I'd check:

The server load. It should be < 1.

install, enable the module "devel" and see how long it takes the server to create the page. It should be < 1 second.

Check the server's error logs.

Check Status Report in Drupal.

Check Recent Log Messages in Drupal.

Where would you check the

jumpthattb commented 10 November 2014 at 03:47

Where would you check the server load?

yeah where do you check the

Anonymous (not verified) commented 11 November 2014 at 06:49

Here's the module Devel Module. But how do you check the server load? Can't find any such option.

For anyone looking at this in

Anonymous (not verified) commented 30 June 2016 at 16:34

For anyone looking at this in the future...

/admin/reports/dblog
or
"Reports" -> "Recent Log Messages" in admin toolbar

Executed 9177 queries in 4131.11 ms. Queries exceeding 5 ms are

wer0ckz commented 10 November 2014 at 11:40

Executed 9177 queries in 4131.11 ms. Queries exceeding 5 ms are highlighted.

9177 queries per page means really high, heavy load on database

bhatmahesht commented 10 November 2014 at 12:55

That's really high number of queries. Normally a drupal site runs around 100 to 200 queries per page load, and page execution time would be around 1 sec. Do cron job runs each time you execute a page? Find out which module is executing so many queries. Is there any module that tries to import data from other files? Find ways to reduce those high number of queries. If a contributed module is running so many queries, try writing a customized module that runs the less number of queries and does almost same functionality.

--
Passionate about Drupal

Thanks

wer0ckz commented 10 November 2014 at 14:30

Thanks i'll check it out

2961 lines of

wer0ckz commented 10 November 2014 at 15:40

Hey guys. I found 2691 lines of this:

SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, base.uuid AS uuid, v.machine_name AS vocabulary_machine_name FROM taxonomy_term_data base INNER JOIN taxonomy_vocabulary v ON base.vid = v.vid WHERE (base.tid IN (:db_condition_placeholder_0))

I guess taxonomy feeds are once causing the slow down?

Please advise.