Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 242881 - Packaging page slow to load
Summary: Packaging page slow to load
Status: RESOLVED FIXED
Alias: None
Product: Community
Classification: Eclipse Foundation
Component: Website (show other bugs)
Version: unspecified   Edit
Hardware: PC Linux
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: phoenix.ui CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-01 10:19 EDT by Denis Roy CLA
Modified: 2008-11-20 16:12 EST (History)
1 user (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Denis Roy CLA 2008-08-01 10:19:06 EDT
The packaging page is slow to load.  I count about 3-4 seconds.

I think one of the reasons is that it launches several queries like this:

mysql> Select count(*) as count from click_count where nid = 110 and platform = 'linux64';
+-------+
| count |
+-------+
|  3082 |
+-------+
1 row in set (0.89 sec)

mysql> SELECT count(*) as count from click_count where nid = 110 AND timestamp > '2008-07-25 10:04:14';
+-------+
| count |
+-------+
| 14793 |
+-------+
1 row in set (0.80 sec)

Do you still need these queries now that we track actual downloads on each file?  Not only does the page load slowly, but our DB server works hard during those numerous 0.80 second queries.
Comment 1 Nathan Gervais CLA 2008-08-11 10:01:41 EDT
These queries have been removed. 

CSS aggregation has also been enabled for the site which should increase the load time of the page by about 5%.  This does not however include the eclipse.org-common files as they require and absolute path to display properly.

I've also investigated Javascript aggregation, and am close to a solution for that.  

Overall the performance of the site has been increased by close to 60% from last week. 
Comment 2 Nathan Gervais CLA 2008-08-11 10:05:02 EDT
Can we get Gzip enabled for the packaging site? This would help the performance as well.
Comment 3 Denis Roy CLA 2008-08-11 10:46:06 EDT
> Can we get Gzip enabled for the packaging site?

It's enabled site-wide.  From what I can see, page load time is indeed 1.6 sec (down from 3-4).  This is starting to make sense, thanks.



time wget --header "Accept-encoding: gzip, deflate" -S -O /dev/null http://www.eclipse.org/downloads/packages/

HTTP request sent, awaiting response...
[snip]
  Content-Encoding: gzip
  Content-Length: 4401

real    0m1.653s
user    0m0.004s
sys     0m0.000s


Comment 4 Nathan Gervais CLA 2008-08-12 11:17:51 EDT
Are .js files included in the GZip settings? 
Comment 5 Denis Roy CLA 2008-08-12 11:26:36 EDT
Yes

# Gzippin' love
DeflateCompressionLevel 2
AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css
AddOutputFilterByType DEFLATE application/atom+xml application/xml application/rdf+xml application/x-javascript
AddOutputFilterByType DEFLATE application/pdf application/x-shockwave-flash
AddOutputFilterByType DEFLATE image/x-icon
Comment 6 Nathan Gervais CLA 2008-08-12 11:37:50 EDT
I'm still showing that some javascript files that are being served from the site aren't being Gzip'd

can you add text/javascript to the list?
Comment 7 Denis Roy CLA 2008-11-20 16:12:17 EST
Meh ... works.  Thanks!