Home » Forums » Ubercart » Support
7 replies [Last post]
Sat, 12/08/2007 - 02:42
mimetic2
mimetic2's picture
Offline
Joined: 08/07/2007
Juice: 478
Was this information Helpful?

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

Top
Sat, 12/08/2007 - 04:45
#1 View page
Alaska
Alaska's picture
Offline
Joined: 10/16/2007
Juice: 1433
Drupal

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

Top
Sat, 12/08/2007 - 17:03
#2 View page
jimijamesi
jimijamesi's picture
Offline
Joined: 08/19/2007
Juice: 75
Re: Server tips? Drupal is slow =/

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.

Top
Sat, 12/08/2007 - 20:43
#3 View page
dharmanerd
dharmanerd's picture
Offline
Joined: 12/04/2007
Juice: 4
Re: Re: Server tips? Drupal is slow =/

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

Top
Sun, 12/09/2007 - 03:41
#4 View page
mimetic2
mimetic2's picture
Offline
Joined: 08/07/2007
Juice: 478
Re: Re: Re: Server tips? Drupal is slow =/

wow thanks guys! amazng tips

Top
Mon, 12/10/2007 - 10:33
#5 View page
Ryan
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Re: Re: Re: Server tips? Drupal is slow =/

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.

Top
Mon, 12/10/2007 - 15:37
#6 View page
torgosPizza
torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: Re: Re: Re: Re: Server tips? Drupal is slow =/

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

--
Help directly fund development: Donate via PayPal!

Top
Wed, 12/12/2007 - 00:09
#7 View page
TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3424
Re: Re: Re: Re: Re: Re: Server tips? Drupal is slow =/

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