Does Drupal 5.x loads slower than 4.7? Is 5.x heavier in terms of server loads?
Rosamunda - February 17, 2008 - 12:18
Hello there!
I´ve recently upgraded 4.7 to 5.x. I´ve not yet to try this on my working site but on another account of the same server, using backup files.
As this is an upgrade, I´ve almost created a copy of the working site, adding a few modules only (I didn´t add ecommerce modules, nor CivicCRM).
But I´ve noted that the pages loads slower than they do in 4.7 version...
Could that be because of the upgrade?
The only major change was that I´ve to stop using flexinodes, and start using CCK, because there are not a 5.x version of flexinode.
Thjanks in advance for your help!!!!!
Rosamunda
Some versions of Drupal 5 do
Some versions of Drupal 5 do seem to use more memory. I think I noticed increased per page memory usage about Drupal 5.3 or 5.5.
Overall, Drupal 5 seems to be significantly speedier than 4.7. There are tons of variables though. You may be using a different version of mysql or php that due to the way it is installed or the equipment it is installed on may be slower, contribute modules may be slower or faster. (I am not aware of any major performance issues with cck, but I don't know how it compares performance-wise to flexinode.)
Also, just because it is 30% faster in most situations, doesn't mean it is faster in every use case.
My best guess is that you changed from php4 to php5 when you upgraded and that it may be running slower because of the way it is installed or even general performance issues. PHP 5 is recommended, but I seem to recall that PHP 4 was a bit faster in general. Also, if PHP5 is running as a cgi or on different hardware or with a different setup, it might be even slower.
Drupal 5 has significantly better caching (assuming you have it turned on), but you won't notice that except as an anonymous user and then only if the page is cached (not on the first view).
The problem is still there
Thanks for your reply!
I´ve turned on the caching mode, and yeah, it increased a bit the anon loading time. But not too much though.
I´ve installed devel, and this is what it tells me:
ms # where query
5.14 1 views_build_view SELECT DISTINCT(node.nid), node.created AS node_created_created, node.title AS node_title, node.changed AS node_changed, node.created AS node_created, users.name AS users_name, users.uid AS users_uid FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid INNER JOIN users users ON node.uid = users.uid WHERE (node.status = '1') AND (term_data.vid = '3') ORDER BY node_created_created DESC LIMIT 0, 10
1.31 1 cache_get SELECT data, created, headers, expire FROM cache_views WHERE cid = 'views_tables:es'
1.08 1 sess_write UPDATE sessions SET uid = 1, cache = 0, hostname = '200.122.21.192', session = 'form|a:3:{s:32:\"204085b97741546af590e5ffd4a56e87\";a:2:{s:9:\"timestamp\";i:1203905308;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"00324d69d26057303a9090c1fbab00cc\";a:2:{s:9:\"timestamp\";i:1203985378;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"bb489e7739e0b6ded1f4631232ae277b\";a:2:{s:9:\"timestamp\";i:1203985412;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}}htmlcode|s:0:\"\";', timestamp = 1203986032 WHERE sid = '2683470d59a7c606c29c57f97fedb522'
0.98 1 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'locale:es'
0.62 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 1894
0.56 1 cache_get SELECT data, created, headers, expire FROM cache_menu WHERE cid = '1:es'
0.48 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 2028
0.46 1 sess_write UPDATE users SET access = 1203986032 WHERE uid = 1
0.44 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 2027
0.41 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 1825
0.38 1 statistics_exit INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('', 'node', 'http://www.planetaconsorcio.com/admin/settings/performance', '200.122.21.192', 1, '2683470d59a7c606c29c57f97fedb522', 1510, 1203986032)
0.3 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1814'
0.27 1 sess_write SELECT sid FROM sessions WHERE sid = '2683470d59a7c606c29c57f97fedb522'
0.26 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/2030'
0.25 1 statistics_get SELECT totalcount, daycount, timestamp FROM node_counter WHERE nid = 1894
0.23 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1423'
0.22 1 _views_load_view SELECT v.* FROM view_view v WHERE v.name = 'novedades_en_articulos'
...
...
...
Apache 1.3.39 (Unix)
MySQL 5.0.45-community-log
PHP 5.2.4
What should I check out in my php configuration?
Thanks again!!!
Rosamunda
I'm out of my league talking
I'm out of my league talking about server optimization. I am lucky just to get one functioning. Just an idea, perhaps you could allocate more memory to serving pages. There are several places you can set this as I recall (with Apache) and any one of them could restrict a process's access to memory.
Really clueless about this
Gee, it seems a jungle out there. I´ll talk once again with my hosting, but as they don´t know how Drupal works, it won´t be easy... i don´t know what really ask them for. Or what should I complain for anyway.
Now I´ve tried to enter again the site, and it took a very long time!!
485.66 1 views_build_view????!!!!
ms # where query
485.66 1 views_build_view SELECT DISTINCT(node.nid), comments.timestamp AS comments_timestamp_timestamp, comments.subject AS comments_subject, comments.cid AS comments_cid, comments.name AS comments_name, comments.uid AS comments_uid, votingapi_cache_votar_points_sum.value AS votingapi_cache_votar_points_sum_value, comments.timestamp AS comments_timestamp FROM node node LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN comments comments ON node.nid = comments.nid LEFT JOIN users_roles users_roles ON node.uid = users_roles.uid LEFT JOIN votingapi_cache votingapi_cache_votar_points_sum ON node.nid = votingapi_cache_votar_points_sum.content_id AND votingapi_cache_votar_points_sum.content_type = 'node' AND votingapi_cache_votar_points_sum.value_type = 'points' AND votingapi_cache_votar_points_sum.tag = 'votar' AND votingapi_cache_votar_points_sum.function = 'sum' WHERE (node_comment_statistics.comment_count > '1') AND (comments.status = '0') AND (node.type IN ('hogaryconsorcio','noticias')) AND ((users_roles.rid NOT IN ('11') OR users_roles.rid IS NULL)) ORDER BY comments_timestamp_timestamp DESC LIMIT 0, 6
191.07 1 block_list SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'internet_services' AND b.status = 1 AND (r.rid IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module
153.74 1 locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'A book is a collaborative writing effort: users can collaborate writing the pages of the book, positioning the pages in the right order, and reviewing or modifying pages previously written. So when you have some information to share or when you read a page of the book and you didn\'t like it, or if you think a certain page could have been written better, you can do something about it.' AND t.locale = 'es'
143.84 2 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:d41d8cd98f00b204e9800998ecf8427e'
122.79 1 statistics_exit INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('', 'node', '', '200.122.41.252', 1, '2683470d59a7c606c29c57f97fedb522', 7486, 1204080251)
122.45 1 cache_get SELECT data, created, headers, expire FROM cache_content WHERE cid = 'content_type_info'
79.05 2 cache_get SELECT data, created, headers, expire FROM cache_views WHERE cid = 'views_urls'
78.72 1 comment_nodeapi SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 1894
74.65 1 cache_get SELECT data, created, headers, expire FROM cache_menu WHERE cid = '1:es'
73.14 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:42273f5f48e873e0865262837dbdcaba'
71.58 1 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 1894 ORDER BY f.fid
61.72 1 cache_get SELECT data, created, headers, expire FROM cache_content WHERE cid = 'content:1894:1894'
57.88 1 views_build_view SELECT DISTINCT(node.nid), node.created AS node_created_created, node.title AS node_title, node.changed AS node_changed, node.created AS node_created, users.name AS users_name, users.uid AS users_uid FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid INNER JOIN users users ON node.uid = users.uid WHERE (node.status = '1') AND (term_data.vid = '3') ORDER BY node_created_created DESC LIMIT 0, 10
47.77 1 pager_query SELECT COUNT(*) FROM node n WHERE n.promote = 1 AND n.status = 1
46.03 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 1894
45.98 1 cache_get SELECT data, created, headers, expire FROM cache_views WHERE cid = 'views_tables:es'
39.11 1 tagadelic_get_weighted_tags SELECT COUNT(*) AS count, d.tid, d.name, d.vid FROM term_data d INNER JOIN term_node n ON d.tid = n.tid WHERE d.vid IN (11) GROUP BY d.tid, d.name, d.vid ORDER BY count DESC LIMIT 0, 25
37.66 1 drupal_lookup_path SELECT COUNT(pid) FROM url_alias
36.1 1 module_list SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
35.26 1 block_block SELECT body, format FROM boxes WHERE bid = 26
33.05 1 views_build_view SELECT DISTINCT(node.nid), node.created AS node_created_created, node.title AS node_title, node.changed AS node_changed, node.created AS node_created, term_data.name AS term_data_name, term_data.tid AS term_data_tid FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid AND term_data.vid IN ('1','2') WHERE (node.status = '1') AND (term_node.tid IS NOT NULL) AND (term_data.tid IS NOT NULL) ORDER BY node_created_created DESC LIMIT 0, 10
32.63 1 locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'An image (with thumbnail). This is ideal for publishing photographs or screenshots.' AND t.locale = 'es'
31.9 1 _views_load_view SELECT * FROM view_exposed_filter WHERE vid = 16 ORDER BY position ASC
30.05 1 filter_format_allowcache SELECT cache FROM filter_formats WHERE format = 2
29.63 1 devel_node_access_block SELECT na.*, n.title FROM node_access na LEFT JOIN node n ON n.nid = na.nid WHERE na.nid IN (0,1894,2028,1825,2027) ORDER BY na.nid
28.13 1 scheduler_nodeapi SELECT * FROM scheduler WHERE nid = 1894
27.62 1 locale_supported_languages SELECT locale, name, formula, enabled FROM locales_meta ORDER BY isdefault DESC, enabled DESC, name ASC
27.31 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 2027
26.91 1 _views_load_view SELECT v.* FROM view_view v WHERE v.name = 'novedades_en_articulos'
25.92 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:f79e9281ac11295c8bff58adaf63248d'
25.7 1 locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'View | Edit | Logout' AND t.locale = 'es'
25.38 1 cache_get SELECT data, created, headers, expire FROM cache WHERE cid = 'locale:es'
25.27 1 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 2028 ORDER BY v.weight, t.weight, t.name
24.6 1 contemplate_get_template SELECT * FROM contemplate WHERE type = 'front'
22.77 1 pager_query SELECT DISTINCT(n.nid), n.sticky, n.created FROM node n WHERE n.promote = 1 AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10
22.62 1 eval SELECT COUNT(DISTINCT(n.nid)) FROM node n WHERE n.type IN('Noticias') AND n.status=1
19.62 1 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 1894 ORDER BY v.weight, t.weight, t.name
17.64 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 2028
15.69 1 eval SELECT COUNT(DISTINCT(n.nid)) FROM node n WHERE n.type IN('HogarYConsorcio') AND n.status=1
15.23 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:fd666886573bd3a27f5807fec369d674'
14.25 1 contemplate_available_files SELECT data FROM contemplate_files WHERE site = 'sites/default'
13.88 1 drupal_lookup_path SELECT src FROM url_alias WHERE dst = 'node'
13.48 1 node_expire_nodeapi SELECT expire, expiremode FROM node_expire WHERE nid = 1894
13.13 1 locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'A question type for the quiz module: allows you to create multiple choice questions (ex: A, B, C, D or true/false)' AND t.locale = 'es'
12.14 1 _node_types_build SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
11.66 1 eval SELECT COUNT(DISTINCT(n.nid)) FROM node n WHERE n.type IN('legislacion') AND n.status=1
11.05 1 _views_load_view SELECT * FROM view_argument WHERE vid = 16 ORDER BY position ASC
10.09 1 node_load SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 1825
9.52 1 captcha_form_alter SELECT module, type FROM captcha_points WHERE form_id = 'search_block_form'
9.2 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:0b29b10365d001e81707fb9970c41275'
9.07 1 book_nodeapi SELECT parent, weight FROM book WHERE vid = 1894
9.03 1 _views_load_view SELECT * FROM view_tablefield WHERE vid = 16 ORDER BY position ASC
8.31 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:cbcc1007a1a54ee5d31f3a3de0e254b5'
7.71 1 statistics_get SELECT totalcount, daycount, timestamp FROM node_counter WHERE nid = 1894
7.35 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:854a485e90b7e70c4210683fdc9ff554'
6.81 1 _views_load_view SELECT * FROM view_sort vs WHERE vid = 16 ORDER BY position ASC
5.53 1 node_access_view_all_nodes SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all') OR (gid = 15 AND realm = 'tac_lite') OR (gid = 85 AND realm = 'tac_lite') OR (gid = 24 AND realm = 'tac_lite') OR (gid = 85 AND realm = 'tac_lite') OR (gid = 87 AND realm = 'tac_lite') OR (gid = 85 AND realm = 'tac_lite') OR (gid = 0 AND realm = 'tac_lite')) AND grant_view >= 1
5.34 1 path_nodeapi SELECT dst FROM url_alias WHERE src = 'node/2028'
4.38 1 _views_load_view SELECT * FROM view_filter WHERE vid = 16 ORDER BY position ASC
3.52 1 eval SELECT COUNT(DISTINCT(n.nid)) FROM node n WHERE n.type IN('legislacion', 'HogarYConsorcio', 'Noticias', 'jornadas_gratuitas') AND n.status=1
3.05 1 taxonomy_get_vocabulary SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 7 ORDER BY v.weight, v.name
1.91 2 taxonomy_get_vocabularies SELECT v.vid, v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE n.type = 'hogaryconsorcio' ORDER BY v.weight, v.name
1.88 1 filter_list_format SELECT * FROM filters WHERE format = 2 ORDER BY weight ASC
1.62 1 _views_load_view SELECT * FROM view_exposed_filter WHERE vid = 17 ORDER BY position ASC
1.62 1 node_expire_nodeapi SELECT expire, expiremode FROM node_expire WHERE nid = 2028
1.36 1 block_block SELECT body, format FROM boxes WHERE bid = 9
1.34 1 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 1825 ORDER BY v.weight, t.weight, t.name
1.14 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/2029'
1.12 1 taxonomy_node_get_terms SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.nid = 2027 ORDER BY v.weight, t.weight, t.name
1.1 1 sess_write UPDATE sessions SET uid = 1, cache = 0, hostname = '200.122.41.252', session = 'form|a:3:{s:32:\"00324d69d26057303a9090c1fbab00cc\";a:2:{s:9:\"timestamp\";i:1203985378;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"bb489e7739e0b6ded1f4631232ae277b\";a:2:{s:9:\"timestamp\";i:1203985412;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}s:32:\"6668a3d700cc9534e77ca09f45493539\";a:2:{s:9:\"timestamp\";i:1203990536;s:4:\"args\";a:1:{i:0;s:14:\"system_modules\";}}}htmlcode|s:0:\"\";', timestamp = 1204080252 WHERE sid = '2683470d59a7c606c29c57f97fedb522'
1.1 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/2030'
1.03 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/296'
1.03 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1823'
1.02 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'taxonomy/term/117'
0.97 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:64aa255e297b975da330b4e8f91b3a5d'
0.96 1 _views_load_view SELECT * FROM view_sort vs WHERE vid = 42 ORDER BY position ASC
0.88 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1770'
0.87 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:9623d03a2a6f165c0e5c110128a041bf'
0.84 1 sess_write UPDATE users SET access = 1204080252 WHERE uid = 1
0.83 1 block_block SELECT body, format FROM boxes WHERE bid = 39
0.82 1 locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Create a new form or questionnaire accessible to users. Submission results and statistics are recorded and accessible to privileged users.' AND t.locale = 'es'
0.79 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:ba4836a1c88e6bec712e8876109b7b88'
0.78 0 locale SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = ' Queries taking longer than %threshold ms and queries executed more than once, are highlighted.' AND t.locale = 'es'
0.77 1 taxonomy_get_term SELECT * FROM term_data WHERE tid = 41
0.77 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'logout'
0.73 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'taxonomy/term/96'
0.71 1 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 2027 ORDER BY f.fid
0.68 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'misc/feed.png'
0.66 1 block_block SELECT body, format FROM boxes WHERE bid = 45
0.65 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1894/edit'
0.64 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1788'
0.64 1 list_themes SELECT * FROM system WHERE type = 'theme'
0.62 1 taxonomy_get_term SELECT * FROM term_data WHERE tid = 10
0.62 1 eval SELECT COUNT(DISTINCT(n.nid)) FROM node n WHERE n.type IN('jornadas_gratuitas') AND n.status=1
0.62 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1824'
0.6 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1813'
0.59 1 system_region_list SELECT * FROM system WHERE type = 'theme' AND name = 'internet_services'
0.57 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'node/1727'
0.57 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '2:0dffa7a7dec3d70aeca3699d6f09f17b'
0.57 1 upload_load SELECT * FROM files f INNER JOIN file_revisions r ON f.fid = r.fid WHERE r.vid = 2028 ORDER BY f.fid
0.56 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'user/14'
0.55 1 _views_load_view SELECT * FROM view_sort vs WHERE vid = 17 ORDER BY position ASC
0.55 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'taxonomy/term/144'
0.54 1 drupal_lookup_path SELECT dst FROM url_alias WHERE src = 'taxonomy/term/128'
0.54 1 cache_get SELECT data, created, headers, expire FROM cache_filter WHERE cid = '3:115bc144e6cb4f2f373bd503a572db82'
If you are using inexpensive
If you are using inexpensive shared hosting, well, don't expect things to be fast. For instance, I use Dreamhost (and like them), but they (as do other hosts) offer essentially unlimited bandwidth and space. The real limits come into play with database and cpu and, to a lesser extent memory.
In other words, I get more bandwidth and space than some dedicated servers paying twenty times as much. I pay for it with slower speed, slow database access, and fairly high cpu loads and other system resources that are overloaded. And heaven forbid that any of the other dozens of users should have a long cron job or a process gone awry or something configured wrong - or that a few of them update their sites to get more traffic or even get slashdotted.
It isn't necessary that your host understand Drupal, but you do have to realize (and you probably already do), that dynamic sites like Drupal tend to hog significantly more resources than static sites and that cheap shared hosts are configured to limit precisely what you are wanting most in many cases.
You´re right, but both sites (faster and) are in the same server
You´re absolutely right, but the weird situetion comes when my actual (faster) site, and the new (slower) 5.0 site that I want to set up propperly and replace the old 4.7, are running in the same server!
Well, not "exactly" the same, as they are 2 different accounts, but within the same company, and the same server characteristics... Except the new slower account have a newser php/mysql version...
When you are talking about
When you are talking about shared hosting, your mileage may vary considerably. Several things can happen. First of all, essentially all configuration is out of your control. Also out of your control is who you share the server with.
In a company that tries to put, for example 100 user accounts on a single server, at any given time, most of those accounts hardly use any server resources. However, when you get more than your fair share of big boys running active forums and other sites, push comes to shove and the server slows to a crawl. It is a pretty big deal to start moving people around to other servers (it isn't too hard for the company, but it is a bother for the typical user), so basically, they may stop loading new accounts on the server, but it can take a long while for things to get leveled out. In extreme cases, a host will actually move (or ask someone to move to another plan or host) an abusive account to another server, particularly is it being slashdotted or something like that.
Two different accounts at the same host will likely be on different servers and may have quite different characteristics even though they are have identical specifications. If you have ssh access, you can probably verify the server you are running on and run top or another program to check the server load.
If you determine that your new host is running more slowly, you can ask your host to move you to a different server. They might be glad to do it or they may deny everything and tell you it is impossible.
If you want more control, you can look for a quality vps host or a dedicated host.