#1225: more performance improvements

there are some actions that need further optimization. Most of them are in this list built with request-log-analyzer:

Process blockers (> 1 sec duration)
ContentViewerController#view_page.html [GET]	22154 hits	68.2%
ProfileController#tag.html [GET]	2344 hits	7.2%
HomeController#index.html [GET]	1561 hits	4.8%
ProfileController#friends.html [GET]	1135 hits	3.5%
ProfileController#sitemap.html [GET]	1070 hits	3.3%
ProfileController#communities.html [GET]	861 hits	2.6%
SearchController#assets.html [GET]	775 hits	2.4%
ProfileController#index.html [GET]	600 hits	1.8%
ProfileController#members.html [GET]	291 hits	0.9%
ContentViewerController#view_page.html [POST]	194 hits	0.6%
ProfileEditorController#index.html [GET]	181 hits	0.6%
NotFoundController#index.html [GET]	142 hits	0.4%
SearchController#index.html [GET]	134 hits	0.4%
AccountController#signup.html [GET]	107 hits	0.3%
SearchController#tag.html [GET]	107 hits	0.3%
CmsController#media_listing.html [GET]	94 hits	0.3%
AccountController#login.html [GET]	73 hits	0.2%
TasksController#index.html [GET]	55 hits	0.2%
ProfileDesignController#index.html [GET]	55 hits	0.2%
CmsController#edit.html [POST]	54 hits	0.2%

-- AntonioTerceiro - 26 Aug 2009

The following actions seem to be specially slow:

• ProfileController#sitemap

Before
Completed in 99.46222 (0 reqs/sec) | Rendering: 65.28646 (65%) | DB: 33.94756 (34%) | 200 OK [http://192.168.1.5/profile/cesarcardoso/sitemap]
Completed in 122.47211 (0 reqs/sec) | Rendering: 89.49927 (73%) | DB: 32.96496 (26%) | 200 OK [http://192.168.1.5/profile/cesarcardoso/sitemap]

After
Completed in 0.77548 (1 reqs/sec) | Rendering: 0.23804 (30%) | DB: 0.28520 (36%) | 200 OK [http://192.168.1.5/profile/cesarcardoso/sitemap]
Completed in 0.11764 (8 reqs/sec) | Rendering: 0.06960 (59%) | DB: 0.04111 (34%) | 200 OK [http://192.168.1.5/profile/cesarcardoso/sitemap]
Completed in 0.10995 (9 reqs/sec) | Rendering: 0.06627 (60%) | DB: 0.03813 (34%) | 200 OK [http://192.168.1.5/profile/cesarcardoso/sitemap]

• SearchController#tags

Before
Completed in 6.60542 (0 reqs/sec) | Rendering: 1.35090 (20%) | DB: 0.88887 (13%) | 200 OK [http://192.168.1.5/tag]
Completed in 5.02183 (0 reqs/sec) | Rendering: 0.88693 (17%) | DB: 0.68419 (13%) | 200 OK [http://192.168.1.5/tag]

After
Completed in 0.33891 (2 reqs/sec) | Rendering: 0.29292 (86%) | DB: 0.01418 (4%) | 200 OK [http://192.168.1.5/tag]
Completed in 0.05226 (19 reqs/sec) | Rendering: 0.03557 (68%) | DB: 0.01106 (21%) | 200 OK [http://192.168.1.5/tag]
Completed in 0.05440 (18 reqs/sec) | Rendering: 0.03655 (67%) | DB: 0.01153 (21%) | 200 OK [http://192.168.1.5/tag]

• SearchController#tag

Before
Completed in 3.53743 (0 reqs/sec) | Rendering: 3.12214 (88%) | DB: 0.35047 (9%) | 200 OK [http://192.168.1.5/tag/software%20livre]
Completed in 3.40076 (0 reqs/sec) | Rendering: 3.14509 (92%) | DB: 0.21009 (6%) | 200 OK [http://192.168.1.5/tag/software%20livre]

After
Completed in 0.11432 (8 reqs/sec) | Rendering: 0.09229 (80%) | DB: 0.01198 (10%) | 200 OK [http://192.168.1.5/tag/software%20livre]
Completed in 0.05995 (16 reqs/sec) | Rendering: 0.03705 (61%) | DB: 0.01560 (26%) | 200 OK [http://192.168.1.5/tag/software%20livre]
Completed in 0.05162 (19 reqs/sec) | Rendering: 0.03403 (65%) | DB: 0.01114 (21%) | 200 OK [http://192.168.1.5/tag/software%20livre]

• ProfileController#tags

Before
Completed in 1.50140 (0 reqs/sec) | Rendering: 0.95136 (63%) | DB: 0.34350 (22%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tags]
Completed in 0.85512 (1 reqs/sec) | Rendering: 0.08364 (9%) | DB: 0.14210 (16%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tags]

After
Completed in 0.58529 (1 reqs/sec) | Rendering: 0.24052 (41%) | DB: 0.11991 (20%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tags]
Completed in 0.10388 (9 reqs/sec) | Rendering: 0.07093 (68%) | DB: 0.02626 (25%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tags]
Completed in 0.17872 (5 reqs/sec) | Rendering: 0.14675 (82%) | DB: 0.02634 (14%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tags]

• ProfileController#tag

Before
Completed in 0.98824 (1 reqs/sec) | Rendering: 0.66511 (67%) | DB: 0.13740 (13%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tag/Bahia]
Completed in 1.10175 (0 reqs/sec) | Rendering: 0.74616 (67%) | DB: 0.15893 (14%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tag/Bahia]

After
Completed in 0.20404 (4 reqs/sec) | Rendering: 0.14612 (71%) | DB: 0.02629 (12%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tag/Bahia]
Completed in 0.10638 (9 reqs/sec) | Rendering: 0.07399 (69%) | DB: 0.02636 (24%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tag/Bahia]
Completed in 0.17703 (5 reqs/sec) | Rendering: 0.14604 (82%) | DB: 0.02576 (14%) | 200 OK [http://192.168.1.5/profile/gerandocidadania/tag/Bahia]

-- AntonioTerceiro - 03 Sep 2009