Home » Forums » Ubercart » Support

Server tips? Drupal is slow =/

Submitted by mimetic2 on Sat, 12/08/2007 - 02:42
mimetic2
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
permalink #1 Sat, 12/08/2007 - 04:45
Alaska
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

permalink #2 Sat, 12/08/2007 - 17:03
jimijamesi
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.

permalink #3 Sat, 12/08/2007 - 20:43
dharmanerd
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).

permalink #4 Sun, 12/09/2007 - 03:41
mimetic2
Posts: 130
 Joined: 08/07/2007

wow thanks guys! amazng tips

permalink #5 Mon, 12/10/2007 - 10:33
Ryan

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.

permalink #6 Mon, 12/10/2007 - 15:37
torgosPizza

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

permalink #7 Wed, 12/12/2007 - 00:09
TR
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>.