High Performance

This group is dedicated to solutions and approaches for high traffic, high performing Drupal sites. As such, it will deal with a lot of information around the rest of a typical Drupal "stack" -- the operating system, web server, database, and PHP tweaks that combine to support the Drupal application.

This is not a support channel or a place to post bug reports.

If you think you have found a bug, use the issue queue for the appropriate project.

If you need support, see http://drupal.org/support for options.

jacobbednarz's picture

Tracking SQL queries

After spending quite a while trying to diagnose the origin of some slow SQL queries, I looked around for some solutions to better identify the query and lessen the time spent for the initial investigation.

One of the options I found was sending through a comment with the SQL which included information such as the class or function. I've wrote an article about doing it here (https://jacobbednarz.github.io/posts/tracking-sql-queries/) but I was wondering if you had any feedback on how you go about tracking what methods or url's are sending what SQL queries within Drupal.

jaydul's picture

Drupal 8 vs drupal 7 performance

Hello everyone.
I m thinking to move on Drupal 8 but before go I want to know about both Drupal 8 vs drupal 7 performance.We don't need security.We need performance about both version.

PS: We don't need more modules only core modules.

Thank you
Jaydul

deja711's picture

Performance issues with INNODB vs MyISAM

Not sure where is the most appropriate post for this, let me know if anybody has suggestion.

I am having performance issues with INNODB. My major issue is that with INNODB I am getting approximately 20 times slower performance than with MyISAM. For the purpose of testing I have used Drupal 7 with devel module installed. Further more I used 2 bare bone servers with default installations so I can do parallel comparisons.

Read more
btopro's picture

Authenticated traffic scale options

I'm wondering if people have any recommendations on scaling authenticated traffic sites?

Context: We've got about 2,500 users, of whom, 50-100 are on at any one time throughout the day. Right now their interactions are on largely static pages so we've gotten away with display_cache / entitycache / APC / Advagg for cache bin optimization so we can deliver pages pretty quickly.

Read more
steveworley's picture

Cache optimisation for admin menu

http://engineering.flitech.net/admin-menu-performance/

Wanted to post this here as Admin Menu is a great module! It allows your to provide quick and easy navigation to the most used parts of your Drupal administration experience. It provides cache clearing and searching and an array of other nice to haves that don't ship with the default Drupal administration menu. However due to the way that the menu needs to be kept up-to-date this module does not scale very well and can be a prime contributor to slow cache rebuilds and memory issues for larger Drupal sites.

Thanks,
Steve

btopro's picture

Memory profiling in hooks

https://drupal.psu.edu/content/memory-profiling-hooks

Wanted to post this to this group as well about my investigation into the memory used by drupal's various hooks in a site that I'm developing. As a result of the monitoring I was able to find ways to either eliminate or mitigate many RAM zapping functions and hooks as well as finding ways to mitigate some other functions (like optimizing the core book module's navigation rendering capabilities).

I used this dropbucket of functions to do the profiling w/ devel to dpm the output dropbucket.org/node/2036

brad.curnow's picture

DOM hacks for speeding up page download times

ATTACHED: comparison of download waterfall before and after applying these hacks to my page.

Hi Team,

I wanted to share with you some techniques I've discovered over the last couple of days that seem to have a noticeable impact on download times. These are especially applicable to pages with large CSS files on first load, as once things get cached it doesn't make much difference.

Read more
kim.pepper's picture

Drupalcon LA 2015 Session proposals

Just thought I'd post my session proposal here to see if anyone else is planning on submitting similar sessions at DrupalCon LA 2015.

https://events.drupal.org/losangeles2015/sessions/drupal-8-performance-i...

jaydul's picture

How to upload bulk Import XML feeds - Content from xml systems to articles/News note

How to bulk Import XML files -Content from xml systems category base to drupal

Hello I have custom CMS we are moving to Drupal.Our custom CMS has bulk post system via XML feed.
We post 1000 articles/News via xml per hour on our CMS.

We need to know how to import bulk xml as Categories (Taxonomy) base.

Here is our xml file below


<?xml version="1.0" encoding="utf-8" standalone="yes"?>

Sports
Title
Image Location

Read more
Subscribe with RSS Syndicate content