#Performance

Hi,
has anyone benchmarked latest Drupal version (currently 9) with Swoole,which is the most performant app server?Laravel framework claims it can achieve 6000+ requests/per second. https://laravel-news.com/laravel-octane
I would like to see similar comparison of Drupal (9) with Swoole.
Thanks

Drupal's core performance options and contrib modules can make a huge difference to performance. How much do each of these contribute to the overall performance? Which one's should you try first? It of course depends on the site and how well the modules are configured.

Earlier this year at the DrupalNYC meetup I tested this with a single site. Does anyone have any similar stats? Google has changed the way it calculates the Lighthouse score so it's always useful to have up-to-date results. Would you be willing to test out different performance modules on your site?

A major issue about scalability with Drupal for authenticated users is the performance issue on a 2-tier architecture (database on a separate instance on the same network).

Can you please confirm or deny my assumptions here?

• Even with a very fast connection between servers (AWS same Availability Zone), there is a small round-trip time between servers (around 0.5ms)
• Typical Drupal page takes hundreds of queries to generate (cache disabled).
• Latency for each query is added up in the page generation time.

In my drupal 8 website I am facing one issue with the performance. Load test is getting failed because of too many connections comming to the database. I am having separate DB server for database.

For 500 concurrent users around 200 - 300 db connections are comming. For 1200 concurrent users around 800 - 1000 db connections.

As Drupal is a db intensive system, above mentioned counts are ok with its normal behaviour or something weird is happening in this case?

As mentioned in a previous post, I am having performance issues with a site I manage, One person has (forcibly) suggested using Squid as a reverse-proxy to improve performance. I have not heard that discussed in any Drupal meeting. I hear Varnish.

I have researched the web on both proxies and have found a lot of useful information, but (at least so far) not answers to these questions.

• Does anyone have experience with both?
• Are there any specific recommendations or concerns with using either?

Thanks,

Leonard Daly

I remember there were high-performance meetups a while ago. I don't see the group so I'm asking LA Drupal. I will be at the meeting tonight if you wish to discuss then.

The site is used world-wide in a shared-hosting environment, but there is little else on the server. It runs Drupal 7 (last updated in December). Sporadically it receives a large number of requests from IP addresses all around the world. Some of the requests are from bots that appear to honor the 'Crawl-delay' of 60 seconds. A (very) few do not.

The percona-query-digest tool is excellent at tracking down queries that kill performance. The queries can be re-written on modified schemas with better indexes and you're golden. Once that's done you need to institure some healthy happy ways to avoid the problem continuing to recur through a little education and some development routines.

In summary: Getting started with a very large project you need to pay attention what? and should i start a base theme or from scratch?

i am starting a very big project with drupal 7. It will be a social media website and contain a lot of data like users info, pages, groups, live feed etc. I will do the design and css myself from scratch.

Getting started this kind of website for good performance in the future what kinds of things I need to pay attention to?

We are starting an Austin High Performance / Large Scale Drupal meet up. It will be targeted at people who develop or want to learn how to develop sites that require sub second response times before caching and sites that can handle millions of visits a day. We could discuss strategies / technologies / coding techniques and infrastructure to achieve these goals. We can meet monthly at my offices, 43rd and Guadalupe. Any interest?

Helllo,

The installation steps mention 3 php modes https://github.com/perusio/drupal-with-nginx#installation
upstream
fastcgi
php fpm

Which one do you recommend? I have not found any benchmarks comparing them. I am using Boost, so nginx will serve lots of static files.