performance

Greetings,

We're preparing to rollout a CDN for our Drupal implementation and would like to get notes of other people's experiences.

We have about 1/2 million images that we primarily want to push out to a network.

There is a CDN module, http://drupal.org/project/cdn, that we've been looking at, however the author states:
"... it doesn't scale yet (yes, that's pretty ironic since the exact goal is better scalability ..."

Thanks,

Arman.

Here at Lonely Planet we have been looking into CCK for our own projects so we can create easily supported sites which don't need developer input to do simple things like adding additional fields.

But during this time I discovered how bad the performance actually is. Like everyone I thought that adding fields that were not multiple or shared you would get the best performance.

Well I was wrong, and spent a while making sure that I was correct. And I was.

So during some other enhancements I needed to fix the CCK so that performance was much better.

This article I wrote should appeal to people interested in high performance Drupal sites. Most of the performance gains are achieved by doing things with the Javascript and Drupal's File API.

http://wimleers.com/article/improving-drupals-page-loading-performance

You can expect another article soon, about the same topic, but then putting it to practice. I'll use the CDN integration module (of which I'm also the maintainer) and the included core patches to do it in just a few simple steps.

MySQL AB and KernelTrap.org's Jeremy Andrews are partnering up to offer an online presentation titled "Achieving Optimal MySQL Performance For Drupal". Aiming to provide a better understanding of how to properly monitor and tune your MySQL database, the online Webinar will take place on Thursday, January 31st, 2008, at 16:00 UTC (11:00 am EST). The presentation will last 45 minutes, followed by 15 minutes for questions and answers. You can sign up for the free event here.

As a site goes live and we do performance tweaking and benchmarking one of the common results is adding database indexes. I post this into the CCK group since one of the common sources of slow queries is for queries against the CCK tables. For example, a site that has a block that queries a field table to look for information about that field for every page load can quickly make its way into the slow query log. Adding an index to the field is likely to be the best solution.

I'm cross posting this from here in case anyone else has any information to share: http://drupal.org/node/187464

Hi Fellow Drupalers,
I'm working on a session for BADCAMP (http://badcamp07.org) where we will walk through some cool, popular and high performance Drupal sites. The main focus here is high-profile, big companies, high traffic. What is the biggest and highest traffic Drupal site out there?

OpenCraft hosted a 3.5 hour seminar that I presented on Drupal performance tuning and optimization. You can find the slides from the presentation there, which can be useful to some of you.

I create a 5.2 and 6.x patch for measuring how much memory a module takes, and also how much the whole Drupal page load takes.

The results are published here: Measuring memory consumption by Drupal bootstrap and modules.

Short version: in Drupal 6, modules are better off than in 5.2, but the bootstrap is a tad larger.

If anyone is interested in replicating the results with more realistic install profiles, please do so and publish your results/findings/recommendations.

Hi all. I've been working on a new project called Advcache (Advanced Cache) which is a package of caching patches (and a controller module) for Drupal 5. It allows you to cache many things which don't get cached normally, and is intended to increase the performance of Drupal sites, especially for authenticated users. Current caching targets include nodes, comments, taxonomy (trees, terms, vocabularies and node-term bindings), paths, search queries, and forums.