Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Use it for questions about Drupal's performance, how to measure, and improve it.

0
votes
0answers
51 views

How should I deal with a vocabulary with many terms?

I'm trying to use Drupal 8, but if Drupal 7 is better for that, I'm ready to go back to Drupal 7. I have a vocabulary that must contain at least 10,000 terms, but they can also become more than 100,...
0
votes
0answers
11 views

variables cache entry [duplicate]

Hello everyone, I've a serious issue with Drupal 7. Due to mysql high load, I sniffed the queries with tcpdump. I noticed that the following two queries were performed many times per ...
0
votes
0answers
34 views

Very slow menu_tree_check_access query - how to debug

I have a Drupal System which is running fine in production and locally but the dev/cons Db seems to have a problem. After looking a bit deeper into it I found that menu_tree_check_access takes 3.8 Sec ...
0
votes
1answer
17 views

db_insert a lot of records

I am struggling to sort out how to insert a lot of records using db_insert Please see below for the code. I can't have a for loop in the array. It breaks but I am dealing with looping through a lot ...
1
vote
1answer
52 views

Increasing performance of cache_form on high traffic sites

I am noticing a significant performance increase in my load testing when this table is small, but due to a large traffic site this is growing very quickly. I have read that it is not a good idea to ...
2
votes
1answer
54 views

Serve Anonymous Pages when users are logged in for some pages

so essentially I have a Drupal website with great performance for anonymous users and terrible performance for logged in users. What I am looking for is a way to serve some pages that logged in users ...
1
vote
0answers
22 views

How can I drill down to find the culprit function? [closed]

I can see high CPU usage when I hit search URL of my Drupal application. I have enabled XHProf module and UProfiler extension on PHP5.6 to find the culprit function. But the report I am getting is ...
2
votes
1answer
175 views

remove link tags in head

I am working on a project involving migrating a site with many static pages to Drupal 8. Since a number of the pages are old blog posts, there's often broken links, broken images, etc. For quality ...
1
vote
0answers
21 views

Page not found errors for images

The site becomes painfully slow at times and when I look into "Recent Log Mesaages" logs such as this is frequently found. The Location shows: http://example.com/sites/default/files/styles/featured/...
1
vote
1answer
44 views

Is it better for performance to disable unused default core views?

I'm seeing 5 views on my site that I'm not using and want to disable to keep things clean and performant, but I worry it could cause a problem somewhere down the road. The views are: Frontpage (...
0
votes
0answers
63 views

Slick + Blazy do not work properly together

When I use Blazy (https://www.drupal.org/project/blazy) and Slick (https://www.drupal.org/project/slick) together then 2 problems occur: every image is loaded "in a square" like it seems, adding ...
0
votes
4answers
697 views

Performance is notoriously slow

This feels like a repeat post but I can't find an actual answer. I just installed Drupal 8.4.4 on an Azure App Service (S3 Standard 4core 7GB RAM / PHP 7.0.6) and Azure Database for MySQL (Standard ...
0
votes
0answers
116 views

Excessive Cache Entity Insert Statements

We've been experiencing performance issues on our Drupal 8 site where the time to first byte (TTFB) is extremely slow (60+ seconds). After installing Devel and reviewing the WebProfiler, we noticed ...
0
votes
0answers
93 views

Why is the cache bin garbage collection in system_cron() so slow?

Cron runs seem to take longer and longer every day for this Drupal 8 site. Pretty much all of the installed modules with cron hooks seem to behave (runs rarely take longer than a couple of seconds). ...
0
votes
0answers
18 views

Is it bad practice to execute attached views manually?

I'm working on a page that combines three different views. The first view provides the page, the second view is attached to the view page and the third view is attached to the second one. I need the ...
0
votes
1answer
59 views

How to change URL images for CDN

I have a website in Drupal 7 with "N" images in Sites/default/files and I need move this images to CDN. This is possible? How can I do? Best regards!
0
votes
1answer
45 views

Hundreds of unserialize requests

I have a large Drupal 7 website on my hands that is very large and has loads of modules (over 200). I am already seeing poor performance symptoms in the FPM logs with max_children limits reached on ...
0
votes
0answers
19 views

Drupal 8 How to inline CSS after Aggregate CSS files [duplicate]

I'm optimizing Google Page Speed Insights for my site on Drupal 8 platform. One of the tasks that need to be inline CSS in style tag. How can I do that? I have used the Advanced CSS / JS ...
0
votes
0answers
159 views

Performance hit from using the Statistics module?

For a site that we will have 99% of users seeing Varnish/Memcached layers, what is the general performance hit to enabling the core Statistics module? The site may have thousands of visitors daily. ...
3
votes
1answer
301 views

Improve D8 performance to access a custom REST controller

Context I'm currently upgrading a site from Drupal 7 to Drupal 8. In the D7 version, there was a custom "proxy" module which served back-end services. Requests starting with a /service prefix, such ...
1
vote
1answer
222 views

Does disabling ini_set() affect performance?

The server administrator deactivated ini_set() and believes that activating it is very effective in server security, and I receive the following warnings on my websites. Warning: ini_set() has been ...
-1
votes
3answers
776 views

Slow Drupal 7 Load Time

I have a 10 second page load time on Drupal 7.52. It has the approximately the same problem on localhost and my server. On my localhost (WAMP) Apache uses an insignificant amount of CPU (3% or less)....
3
votes
2answers
225 views

Rules: Load List of Entities by Object or Entity ID (Performance)

I'm looking to load a list of Users by an Entity Reference Property within Rules. There may be times when I need to load hundreds or thousands of Users that have a matching Property to update a ...
0
votes
1answer
51 views

Nightly truncating all cache_* tables? Good or bad?

I'm having some issues on various D7 sites with some cache tables growing stupidly large (e.g cache_metadata or cache_menu) which then makes drush cc all very slow (more than 1 minute). Do you think ...
1
vote
2answers
118 views

How do I setup Drupal/Varnish caching so Content Editors don't see browser-cached pages after logging in?

I've got a bit of a situation going on with our caching solution and would love some input. We use a solution of HAProxy -> Varnish -> Apache. HAProxy terminates SSL and sends that to Varnish which ...
0
votes
1answer
55 views

Most performant way to check if a user is referenced in any node of a specified type?

I need to get a list of all users that have a specific role. Those users can be referenced in a multivalue field of a specific content type; some users are referenced in multiple nodes of that content ...
1
vote
0answers
20 views

Site flashes intermediate 'Redirecting to …' page

On a local development site an intermediate 'Redirecting to ...' page flashes for a second before rendering the correct page. This seems to be happening at various places, even on cron run page. The ...
-1
votes
1answer
17 views

Image Optimaization

Dears, i have images with 2000 * 700 pixel and i have to render those images in two different places one with original diminution while the second is with 100 * 60 pixel so each time i have to load ...
3
votes
0answers
175 views

Forms get glitchy with too many nested paragraphs

We have built a complicated structure for building pages out of paragraph components, but are now quickly running into performance limitations. It seems that the node form is monolithic, and is built,...
0
votes
1answer
339 views

Data coming from entityTypeManager->getStorage is cached data?

I am working on one Drupal 8.3 site. I created my own custom Authentication provider for REST API authorisation. Following are the "authenticate" method sample code. /** * {@inheritdoc} */ ...
-1
votes
1answer
17 views

How do uploaded photos and files impact search performance?

I am creating a Drupal site where performance is a key goal and have a few questions: Does Drupal store the photos in the same table as the rest of the node's fields? Will enabling photo uploads on ...
0
votes
1answer
24 views

Checking site performance on remote vs. locally [closed]

I had read a blog article recently describing how to set the settings on your local host to be a reasonable comparison to a remote host in order to test Drupal configurations and performance issues ...
0
votes
1answer
148 views

Microkernel with low bootstrap level?

Drupal 7 had a neat feature of different bootstrap levels that allowed to write really fast micro services that didn't require to fully bootstrap Drupal. Drupal bootstrap levels no longer exists in ...
1
vote
0answers
116 views

What is the performance impact of having many modules in D8?

I like to keep my custom code as separated as possible (in the way it makes sense). In D7 I know it could be crucial (source) because every module used it's .module file and since module files getting ...
1
vote
1answer
43 views

What does “Prefetch views unpack data” in APDQC module do?

There is an option in the APDQC (Asynchronous Prefetch Database Query Cache) https://www.drupal.org/project/apdqc module for: Prefetch views unpack data It's unclear what this does. Should this be ...
3
votes
1answer
96 views

Is putting content in the codebase or the database better for performance?

I recently created a website footer using a block template. Some of the footer's content was entered through the block's wysiwyg (stored in the database), but other code-heavy elements were placed in ...
1
vote
0answers
31 views

Speed up AJAX loading on manage display page when moving fields among regions

When I'm switching my fields into different regions, it takes at least 20 seconds to make it change. I'm not able to change any other field while I wait. The only work around to this was to disable ...
2
votes
2answers
566 views

How to implement a searchable addresses database (for a form)?

I'm not sure if I should ask this type of question in this site, but I already tried to ask in the Drupal forum here with no reply so far. I'm trying to find out the best way to implement a solution ...
0
votes
1answer
88 views

Drupal 8: Performance Impact of frequently clearing all caches

I have a relatively large production site that uses some custom views to filter by taxonomys and other factors through dropdowns. I have come across the issue that adding a new taxonomy does not allow ...
1
vote
1answer
41 views

Drupal 7 Breaks CSS Rule Ordering Standards when CSS Aggregation is Turned On [closed]

Drupal 7 has an interesting bug (some may consider this a feature) when rules are included before an external CSS document is included using @import. The CSS Aggregation engine will let you "bend the ...
2
votes
2answers
282 views

How to delete nodes without taking a lot of time?

My site has about 200 000 nodes. When I want to delete let say 200 nodes it takes about 2hr. I have also installed commerce module, views and a lot of the usual modules. What can I do to speed things ...
2
votes
0answers
199 views

How do I get queries and query count for a page?

In Drupal 7 the query log of the Devel module contained a table which had a query log with a much better overview than what Webprofiler is offering for Drupal 8. In Drupal 8 there's no aggregation or ...
1
vote
0answers
47 views

How do I call a PHP function in all the pages? [closed]

I used the Boost module for performance issues, and it creates _.html files every time it serves a file from the cache. I need to write a PHP function it should call every page, even the cached ones. ...
4
votes
3answers
1k views

Difference between drupal_static and \Drupal::state?

Imagine I have a hard to compute function or value. $my_heavy_value = function($val) { // Hard to compute value. return strtoupper($val); }; What's the difference at performance level between ...
-1
votes
1answer
219 views

How to improve the speed of drupal website [closed]

I have tested my site with testmysite.thinkwithgoogle.com. I got the below report. Speed test score for mobile site and desktop site are not good. If you could help me pointing to right direction to ...
1
vote
1answer
96 views

Is there any way to “linux nice” a process to have less priority

We have some high resource views that would have less impact on the overall performance if they ran at a low priority, e.g. linux nice'd to a low priority.
3
votes
1answer
263 views

how to optimize inline images in ck-editor

Is it possible to optimize inline images uploaded via ck-editor. There is an image with size 11 MB and in default behavior its rendered original without any optimization applied to it.
1
vote
1answer
144 views

Improve extremely slow 'drupal_process_form' [closed]

I am having problem investigating why our profile edit page is damn slow. Call Stack # Time Memory Function Location 1 0.0003 276344 {main}( ) ...\index.php:0 2 1.6889 39666816 ...
3
votes
1answer
39 views

Is there some way to compress CSS and Javascript only for certain users?

When I check the source of my web pages I am appalled at the amount of Javascript links in the page, but I have disabled the CSS and JS compression as I am often in development mode. Is there some ...
1
vote
1answer
59 views

Should one avoid lots of use statements in a custom modules .module file?

Should one avoid lots of use statements in a custom modules .module file? Or does it not matter? To quanity "lots", let's say, using 7 to 10 "use" statements. use Drupal\Core\Entity\EntityInterface;...