Here are the slides from my Drupal Camp Toronto 2012 session.
The site is ScienceScape.org, a repository of scientific research going back to the 19th century, down to the latest biotechnology and cancer release.
Update: You can watch a video of the presentation on Vimeo.
| Attachment | Size |
|---|---|
 drupal-site-with-huge-database-and-lots-of-modules.pdf | 535.43 KB |
Is your Drupal or Backdrop CMS site slow?
Is it suffering from server resources shortages?
Is it experiencing outages?
Contact us for Drupal or Backdrop CMS Performance Optimization and Tuning Consulting
List of recent content on this site.
Do you use any of our Drupal modules?
Did you find our Drupal, Backdrop CMS and LAMP performance articles informative?
Contact us for Drupal and Backdrop CMS Performance Optimization and Tuning Consulting
Comments
dawehner (not verified)
Great presentation with good
Mon, 2012/11/19 - 13:13Great presentation with good ideas.
Due to some aggressive feature-usage on one of our sites, this script would be really interesting!
mikeytown2 (not verified)
Great Slide Deck
Mon, 2012/11/19 - 16:16Nice solution for the database import and reducing the number of installed modules by creating a mega feature.
Did you come up with a solution for PHP network calls in regards to Sphinx?
Khalid
Working on it
Mon, 2012/11/19 - 16:20My understanding is that their staff are working on reducing the number of calls to Sphinx.
You can check here for: Mydumper for fast MySQL backups.
mikeytown2 (not verified)
Drupal 6 or 7 site?
Mon, 2012/11/19 - 16:29Just curious, is this a Drupal 6 or 7 site? My guess is D6 because you list issues with module_hooks & module_implements. If it is D6 http://groups.drupal.org/node/187209 has a list of core patches "Big Performance Gains - Low Risk" that really help with these.
In regards to network traffic, if it is over http http://drupal.org/project/httprl/ is a trick that I use for speeding up parallel http requests. Also, if you have to do something that takes a long time using multiple processes to do it can help: http://groups.drupal.org/node/226054
Khalid
Drupal 6
Mon, 2012/11/19 - 16:35The site is Pressflow 6.
robert (not verified)
I thought the presentation
Fri, 2014/11/14 - 09:30I thought the presentation and what you did was really cool and I was more aghast at the database size.
Melissa (not verified)
Hey, posted this to Reddit.
Mon, 2012/11/19 - 19:34Hey, posted this to Reddit. Sorry if it seemed from the title that I was horrified by it- actually I thought the presentation and what you did was really cool and I was more aghast at the database size.
Great work! Thanks for posting it!
Khalid
No worries
Mon, 2012/11/19 - 19:38No worries. Glad it was clarified, and at least some people got something out of it. That is what it is all about: knowledge sharing within the community.
Amit Goyal (not verified)
Can we hear/see this in audio/video format?
Sat, 2012/11/24 - 10:53Amzed with the presentation! Just wondering if we can have access to audio/video of the session?
Khalid
Maybe later
Sat, 2012/11/24 - 12:23Audio was recorded along with slides. However, it has not been posted yet. I will update the info above to add a link when I get it.