home forums resources search newsjoinmembers: 5824
Main Network: Joomla Wordpress Drupal Drupal.se Fireorb Flash Java PHP Ruby Windows Linux
 videos
 articles
 blogs
 comments
 downloads
sitemap
Hiveminds | Mon, 2006-04-17 21:11  tags: , , ,
friendly: printshare: delicious, digg, reddit, icerocket

Description

Drupal 4.6 Path Aliasing causes a large server load and uses a high number of database queries. These files are the patched replacements for backporting the fix for this problem from Drupal 4.7 to 4.6. This bug was not fixed before Drupal 4.6 was frozen and so this patches never made it into the 4.6.5 release. Since it is not a security fix it is not expected to be added later. Websites with a high number of pages and users will benefit from this improvement most.

The files here were created by hand and test without using the unix patch diff and tested. This is a great convenience for website owners that are not programmers and need to make a significant improvement on resource usage when Drupal 4.6 is run in a shared hosting environment.

Just a note: the patch would NOT run for me using stock 4.6.5 files. (Failed, Failed, Failed) I had to patch each file manually. I hope it is ok that I attached a zip with all the patched files (4.6.5 Stock). Patching is a PAIN in the rear for those of us who are not Unix smart / web developers.

Anyway that said, here are a few quick before & after stats.

HomePage - 189 queries
Before: 269.98ms
After: 60.26ms

Forum Topic - 401 queries
Before: 574.00ms
After: 70.41ms

Page - 160 queries
Before: 424.58ms
After: 52.45ms

-- Marand B.

File: login or register to download  Author:

Hiveminds's picture
This article brought to you by the Hiveminds Magazine - Staff. Contact us if you want to post an article or announcement anonymously
friendly: printshare: delicious, digg, reddit, icerocket
 
toma posted on: Tue, 2006-03-21 13:59.

Thanks a lot you really save my time, when i unzip the file i get :
drupal-4.6.5-full-pathalias-patched
bootstrap.inc
common.inc
updates.inc
where i have to copy
bootstrap.inc
common.inc
updates.inc
its already on includes directory
bootstrap.inc
common.inc
Is there any sql change or just i need a copy past to the server, can you give more info

Thanks

Hiveminds posted on: Tue, 2006-03-21 14:53.

If you have a site already then just make a backup of the old files and copy these new ones on to the server.

If you are creating a new site then use the larger full drupal install.

Hivemindz Magazine - Editor

Amazon Web Services Ad Alexa Toolbar Ad Put Your Site Here Developer's Corner Ad
 

Newsletter

Get updates on Hiveminds services, articles and downloads by signing up for the newsletter.

Editor's choice

Some of the better articles, stories and tutorials found at Hiveminds.

Find more

Find more of Hiveminds articles, stories, tutorials and user comments by searching.




Picked links

Hand picked websites and articles from around the web that provide quality reading.

page top