Search through our group's posts (events, discussions, jobs, etc.) and their comments here. Results are displayed in order of post date. Use the pager below to browse results.
I would like a tiny bit help re-writing db_query to use bind variables
Basically I can remember from my oracle days, of the power of bind variables.
As drupal has a lot of queries, that are repeating, with just a change in variables.
For example cache_get function which has a query like:
SELECT SQL_CACHE data, created, headers, expire, serialized FROM drupal_cache_menu WHERE cid = 'links:navigation:page-cid:node:1'
Well i have already added the SQL_CACHE statement, but in addition, i want to replace db_query, so for certain repeated queries, we can use bind variales.
Read moreAnother CDN idea i had regarding ImageShack
Yes, i read and have Steve Souder's book on High Performance.
One of the ideas, I learned from there, is to upload all my images to www.imageshack.us, which is free, then in my code, refer to the new urls.
Now I have also learned they have an api, which i have just started to play with.
Why not have a few of us create a module, that checks for local images being used in db/blocks/css etc, then uploads them to imageshack, and then grabs the new imageshack url, then put that url in all references to old images.
Read moreStatic page cache and compression limits for shared hosting
Hello
I have set up an aggressive static page caching system using Boost module, which I modified to build gzip compressed pages to speed up load times and be able to serve more pages in less time at cuentosparadormir.com. The system works fine with just a few thousand users in a typical shared hosting account, as the content is oriented mainly to anonymous users. Of course javascript and css files are aggregated and compressed (using smartcache module).
Have anyone tried a similar approach? what do you think the limits of such a set up could be, and what should be the next bottleneck I will face for these kind of sites? do you propose any other configuration to create a high performance drupal site in a shared hosting account?
Read moreDrupalcon Szeged performance session
The Drupalcon performance session is the most popular session, or certainly one of the most popular sessions. We will probably have access to the keynote room for this session. For Drupalcon Boston, we brought together a team of 7 performance experts who presented on a variety of topics. Two of them did so well that they are now admins on Drupal.org itself.
If you are interested in presenting in the Drupalcon Performance session, please indicate what part of performance you would like to address.
Read more
MySQL Binary Logs of Death
I'm running a high traffic Drupal site and having trouble with large MySQL binary logs being created (up to 1Gb every ~30mins at peak times). MySQL server disk space gets filled up before logs can rotate so the site falls over.
The site is multi-lingual, with normal-mode page caching enabled. I wondered whether any other High Performance Drupal ninjas had any experience with such problems. Any help or insight much appreciated.
Read moreHosting, routing and performance conundrum
I have a site that will be heavily used in only six or eight states but they are on different sides of the continental US. I found a really fast host on the east coast with super service, etc, but whenever there is heavy network traffic, it is dog slow on the west coast. I imagine the opposite is true. I found this by doing a tracert and seeing that the big delay was in the middle of the country.
Does anyone have any thoughts or advice on how to select a host for best performance in this case? It is truly a conundrum.
Read more
Possible improvement with caches
Hi,
I would like to share some thoughts about caching in Drupal, and then see what you people think about it. Not sure if this is new though.
Sometimes, cached objects are created on demand (while a page request occurs) and use expiration times. For exemple, cache_filter table usage in check_markup. In these cases, the logic is more or less, like this:
if ($cached = cache_get($cache_id, 'cache_filter')) {
return $cached->data;
}
// object is not cached, so here we do a lot of stuff to
// build the thing, then cache it with an expiration time
cache_set($cache_id, $text, 'cache_filter', time() + (60 * 60 * 24));Well, the problem here is that if several page requests come at the same time, there will be several processes doing the same job and caching the same object, concurrently. For hi traffic sites this might be a problem.
Read more
Surviving social-media traffic spikes: 5 simple performance tips
I just wrote a new article called How I Survived a 2300% Traffic Increase With Drupal. It documents my experience with hitting the front page of Reddit, and some of the steps I took to make sure my site stayed online.
I also included some nice traffic graphs and statistics. If you ever wondered what kind of numbers to expect from a front-page link on a big social news site, be sure to check it out.
--
John Forsythe
Performance benefits of running Lighttpd (or other non-Apache servers)?
Anybody have an experience using alternative web server configurations with Drupal?
I'm currently using Apache 2.0.x & mod_php to serve Drupal 5 along with a separate Lighttpd install for static content. Lighty's been doing such a good job with the images, I'm considering running Drupal on it too with FastCGI. Anybody have any experience with that? Was there a noticable performance benefit?
What about ngnix?
Read moreSlow queries - Problem with accessing Content management -> content
We have just installed the latest version of Drupal 5 on a new site and loaded it up with content, about 4.1 million nodes. These nodes are split between three types of content types, which amounts to around 2.6 mill, 1.5 mill and 70.000 nodes for each type.
Hitting the administrator menu : Content management -> content destroys performance beyond anything I've seen :)
This is the query which totally smother the performance, taken from the developer module:
