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 |
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.