Server tips? Drupal is slow =/

Posts: 130
Joined: 08/07/2007

Hi Guys,

Does anyone have some server tips? For some reason www.ecopaper.com is terribly slow. I dont know how i coulod make it faster. I have such an amazing shopping cart but gonig from product to product takes ages.

Anyone know what to do? I assume this should be a good thread. Optimizing ubercart/drupal.

Aaron

Posts: 364
Joined: 10/16/2007

Another good source for information is drupal.org. Found 178 comments when searching for 'slow server'. All may not be on topic, but the Drupal forum is a great resource.

Jim

Posts: 34
Joined: 08/19/2007

I am having a similar problem...posted here...
http://www.ubercart.org/forum/support/1965/noncached_load_time

I installed and turned on devel module which told me that the pager_query was taking up most of the delay (in some cases 60 -90 seconds) seems as tho the query does some counts which may take extra time

After investigating further... it turns out the server was paging massively to disk eventually resulting in seek errors, I am upgrading ram and hard drive currently to try and ease page load times.

beyond that there are some good mysql performance tuning hints on drupal.org and mysql site

I would advise benchmarking and trying one thing at a time to discover what activity is helping most. start with devel module.

Posts: 3
Joined: 12/04/2007

Log slow queries with mysql and fix any you find.

Use Gzip.

Minify your js and css.
http://wonko.com/article/519

Remove your godaddy seal or store it on your server, same with the google urchin js (you may have to modify the ubercart module to use a local file).

Posts: 130
Joined: 08/07/2007

wow thanks guys! amazng tips

Posts: 5269
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

I don't know all the details, but Andy enabled MySQL querycache on our servers which improved SELECT performance exponentially... Our restaurant equipment site was dragging b/c of the catalog size until that was set.

Posts: 1293
Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

Minify looks awesome, but I am 8 minor versions behind in PHP. Bah.

I wish there was an option in Drupal to do this, similar to the CSS aggregation. (Which I use and does seem to help).

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com

Posts: 924
Joined: 11/05/2007
Bug FinderFAQ ModeratorGetting busy with the Ubercode.

I found this discussion on the drupal.org to be useful: http://drupal.org/node/85768

In particular, get and use the script mentioned there, http://forge.mysql.com/projects/view.php?id=44

--

<tr>.