[development] Two performance improvements
Jakub Suchy
jakub at rtfm.cz
Thu Jul 13 14:57:11 UTC 2006
Jakub Suchy wrote:
> Alan Dixon wrote:
> > since you're using i18n and 4.6, this sounds like it might be this issue:
> >
> > http://drupal.org/node/65801
> > which can be mitigated with an index but is really a sort of a
> > complicated bug about the init_ hook.
>
> Applied the patch, but nothing changed. Not this issue...Still getting
> times about 1-1.5 seconds.
Attaching devel.module output, the source = '' query is still the
slowest. I don't get it, where it appears...
Jakub
-------------- next part --------------
76.85 6 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = '' AND t.locale = 'cs'
70.32 1 SELECT * FROM variable WHERE name like 'event_nodeapi_%'
69.92 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Pathauto' AND t.locale = 'cs'
55.03 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'May' AND t.locale = 'cs'
51.12 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Preview' AND t.locale = 'cs'
50.02 1 SELECT * FROM files WHERE nid = 120
46.96 1 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:3b79e293490a1ca12d7cfc15aab693bf'
46.27 1 SELECT n.nid as nid, n.title as title, fd.textual_data as textual_data, n.changed as changed from flexinode_data fd, node n where fd.field_id = 1 and fd.nid = n.nid and n.language = 'cs' order by n.changed desc limit 0,5
45.96 1 SELECT * FROM boxes WHERE bid = 3
41.64 1 SELECT locale, name FROM locales_meta WHERE enabled = 1 ORDER BY isdefault DESC, name ASC
37.92 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Trainings' AND t.locale = 'cs'
32 1 SELECT n.nid, n.sticky, n.created FROM node n WHERE (n.language ='cs') AND n.promote = 1 AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10
24.86 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Indikacni a testovaci pristroje' AND t.locale = 'cs'
24.22 1 SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =73 WHERE n.nid != 73 AND n.language = 'cs'
20.22 1 SELECT * FROM blocks WHERE status = 1 AND region IN (0) ORDER BY weight, module
18.31 1 SELECT t.tid, t.*, parent FROM term_data t, term_hierarchy h WHERE (t.language ='cs' or t.language = '') AND t.tid = h.tid AND t.vid = 21 ORDER BY weight, name
18.28 1 SELECT t.tid, t.* FROM term_data t, term_node r WHERE (t.language ='cs' or t.language = '') AND r.tid = t.tid AND r.nid = 120 ORDER BY weight, name
18.27 1 SELECT COUNT(*) FROM node_access WHERE nid = 0 AND CONCAT(realm, gid) IN ('all0') AND grant_view = 1
17.2 1 SELECT n.nid, n.title, n.type, n.status, n.moderate, n.teaser, e.event_start FROM node n INNER JOIN event e USING (nid) WHERE (n.language ='cs') AND n.status = 1 AND n.moderate = 0 AND e.event_start >= 1152795217 ORDER BY event_start LIMIT 0, 1
16.36 1 SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE (v.language ='cs' or v.language = '') ORDER BY v.weight, v.name
16.2 1 SELECT data, created, headers FROM cache WHERE cid = 'menu:1:cs'
15.61 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'hl. m. Praha' AND t.locale = 'cs'
14.84 1 SELECT * FROM flexinode_type
13.93 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'edit primary links' AND t.locale = 'cs'
12.68 1 SELECT data, created, headers FROM cache WHERE cid = 'locale:cs'
12.44 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Distributors' AND t.locale = 'cs'
9.73 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Europe' AND t.locale = 'cs'
8.85 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'SALTEK Trainings' AND t.locale = 'cs'
8.36 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Poland' AND t.locale = 'cs'
4.91 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Olomoucký kraj' AND t.locale = 'cs'
4.75 1 SELECT * FROM flexinode_field WHERE ctype_id = 6 ORDER BY weight ASC, label ASC
2.53 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'My Languages' AND t.locale = 'cs'
2.47 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Moravskoslezský kraj' AND t.locale = 'cs'
2.13 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Slovakia' AND t.locale = 'cs'
1.91 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = '%count[2] days' AND t.locale = 'cs'
1.83 1 SELECT t.tid, t.* FROM term_data t, term_node r WHERE (t.language ='cs' or t.language = '') AND r.tid = t.tid AND r.nid = 97 ORDER BY weight, name
1.81 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Next SALTEK s.r.o training is scheduled at %d in: <i>%s</i>' AND t.locale = 'cs'
1.75 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Contact us' AND t.locale = 'cs'
1.74 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Read the rest of this posting.' AND t.locale = 'cs'
1.73 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'View user profile.' AND t.locale = 'cs'
1.72 1 SELECT t.tid, t.* FROM term_data t, term_node r WHERE (t.language ='cs' or t.language = '') AND r.tid = t.tid AND r.nid = 98 ORDER BY weight, name
1.72 1 SELECT t.tid, t.* FROM term_data t, term_node r WHERE (t.language ='cs' or t.language = '') AND r.tid = t.tid AND r.nid = 96 ORDER BY weight, name
1.72 1 SELECT t.tid, t.* FROM term_data t, term_node r WHERE (t.language ='cs' or t.language = '') AND r.tid = t.tid AND r.nid = 87 ORDER BY weight, name
1.7 1 SELECT t.tid, t.* FROM term_data t, term_node r WHERE (t.language ='cs' or t.language = '') AND r.tid = t.tid AND r.nid = 112 ORDER BY weight, name
1.7 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'News' AND t.locale = 'cs'
1.71 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Seznam dodavatelů' AND t.locale = 'cs'
1.69 1 SELECT t.tid, t.* FROM term_data t, term_node r WHERE (t.language ='cs' or t.language = '') AND r.tid = t.tid AND r.nid = 115 ORDER BY weight, name
1.69 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Enter the terms you wish to search for.' AND t.locale = 'cs'
1.68 1 SELECT t.tid, t.* FROM term_data t, term_node r WHERE (t.language ='cs' or t.language = '') AND r.tid = t.tid AND r.nid = 99 ORDER BY weight, name
1.66 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Ochrana telekomunikaci, radiokomunikaci a bezdratoveho pripojeni' AND t.locale = 'cs'
1.63 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Ochrana datovych siti, videorozvodu, LAN' AND t.locale = 'cs'
1.61 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Austria' AND t.locale = 'cs'
1.59 1 SELECT * FROM url_alias
1.47 1 SELECT t.tid, t.*, parent FROM term_data t, term_hierarchy h WHERE (t.language ='cs' or t.language = '') AND t.tid = h.tid AND t.vid = 12 ORDER BY weight, name
1.44 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'edit secondary links' AND t.locale = 'cs'
1.42 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'read more' AND t.locale = 'cs'
1.4 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Pardubický kraj' AND t.locale = 'cs'
1.39 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Surge arresters' AND t.locale = 'cs'
1.39 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'search' AND t.locale = 'cs'
1.39 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'more info' AND t.locale = 'cs'
1.38 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Jihočeský kraj' AND t.locale = 'cs'
1.37 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Lightning protection' AND t.locale = 'cs'
1.37 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Great Britain' AND t.locale = 'cs'
1.37 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Germany' AND t.locale = 'cs'
1.3 6 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = '' AND t.locale = 'cs'
1.3 6 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = '' AND t.locale = 'cs'
1.36 6 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = '' AND t.locale = 'cs'
1.36 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Ústecký kraj' AND t.locale = 'cs'
1.36 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Submit' AND t.locale = 'cs'
1.36 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'July' AND t.locale = 'cs'
1.35 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'more about company' AND t.locale = 'cs'
1.34 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Základní ochrana nn - 1. a 2. stupeň' AND t.locale = 'cs'
1.34 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Plzeňský kraj' AND t.locale = 'cs'
1.34 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Karlovarský kraj' AND t.locale = 'cs'
1.33 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Russia' AND t.locale = 'cs'
1.33 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Ochrana signalovych linek' AND t.locale = 'cs'
1.33 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Delete' AND t.locale = 'cs'
1.33 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Catalogue' AND t.locale = 'cs'
1.32 6 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = '' AND t.locale = 'cs'
1.32 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Královehradecký kraj' AND t.locale = 'cs'
1.32 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Katalog' AND t.locale = 'cs'
1.32 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Jihomoravský kraj' AND t.locale = 'cs'
1.3 1 SELECT t.tid, t.*, parent FROM term_data t, term_hierarchy h WHERE (t.language ='cs' or t.language = '') AND t.tid = h.tid AND t.vid = 2 ORDER BY weight, name
1.3 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Liberecký kraj' AND t.locale = 'cs'
1.3 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'enter catalogue' AND t.locale = 'cs'
1.3 1 SELECT COUNT(*) FROM node n WHERE (n.language ='cs') AND n.promote = 1 AND n.status = 1
1.31 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Zlínský kraj' AND t.locale = 'cs'
1.31 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Středočeský kraj' AND t.locale = 'cs'
1.31 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Home' AND t.locale = 'cs'
1.29 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = ' Page execution time was %time ms.' AND t.locale = 'cs'
1.29 1 SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE (v.language ='cs' or v.language = '') AND v.language = 'cs' AND (v.vid = 9 OR v.vid = 10 OR v.vid = 11 OR v.vid = 2 OR v.vid = 22 OR v.vid = 23) ORDER BY v.weight, v.name
1.27 6 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = '' AND t.locale = 'cs'
1.27 1 SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = 'Vysočina' AND t.locale = 'cs'
1 1 SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = '87'
1.17 1 SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = '112'
1.17 1 SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =39 WHERE n.nid != 39 AND n.language = 'cs'
1.16 1 SELECT data, created, headers FROM cache WHERE cid = 'filter:3:77f7a2f235c183cffda6be1a4fb51da9'
1.1 1 SELECT * FROM system WHERE type = 'theme' ORDER BY name
1.11 1 SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =0 WHERE n.nid != 0 AND n.language = 'ru'
1.09 1 SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = '115'
1.08 1 SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =0 WHERE n.nid != 0 AND n.language = 'sk'
1.05 1 SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =0 WHERE n.nid != 0 AND n.language = 'pl'
1.05 1 SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =0 WHERE n.nid != 0 AND n.language = 'en'
1.04 1 SELECT * FROM blocks WHERE status = 1 AND region IN (99) ORDER BY weight, module
1.02 1 SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =0 WHERE n.nid != 0 AND n.language = 'de'
1.01 4 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:d9729feb74992cc3482b350163a1a010'
1.01 1 SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = '120'
1.01 1 SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =0 WHERE n.nid != 0 AND n.language = 'cs'
1.01 1 SELECT name, filename, throttle, bootstrap FROM system WHERE type = 'module' AND status = 1
0.99 1 SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = '97'
0.98 1 SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = '96'
0.98 1 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:818fac81d521ec67708241219fce08d8'
0.96 1 SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = '98'
0.95 4 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:d9729feb74992cc3482b350163a1a010'
0.95 1 SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.nid = '99'
0.94 4 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:d9729feb74992cc3482b350163a1a010'
0.94 1 SELECT locale, name, formula, enabled FROM locales_meta ORDER BY isdefault DESC, enabled DESC, name ASC
0.94 1 SELECT data, created, headers FROM cache WHERE cid = 'filter:3:3780816ed97ef5084fef91e4ca0391d5'
0.92 4 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:d9729feb74992cc3482b350163a1a010'
0.9 1 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:b68305626ad5527fcad5677fb4cf41ea'
0.9 1 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:6719e5c0743e38bf5491f24cbd4d1613'
0.88 1 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:774bd63a6045b276c7f9ae283e6b5b73'
0.86 1 SELECT data, created, headers FROM cache WHERE cid = 'filter:1:140fa2430ff061256db74fab75349f11'
0.84 1 SELECT * FROM blocks WHERE status = 1 AND region IN (1) ORDER BY weight, module
0.83 1 SELECT * FROM files WHERE nid = 112
0.7 1 SELECT * FROM flexinode_type WHERE ctype_id = 6
0.71 1 SELECT * FROM signup WHERE nid = 120
0.71 1 SELECT * FROM boxes WHERE bid = 8
0.68 1 SELECT * FROM boxes WHERE bid = 1
0.67 1 SELECT * FROM signup WHERE nid = 115
0.67 1 SELECT * FROM boxes WHERE bid = 5
0.66 1 SELECT * FROM signup WHERE nid = 87
0.66 1 SELECT * FROM signup WHERE nid = 112
0.63 1 SELECT * FROM signup WHERE nid = 96
0.63 1 SELECT * FROM files WHERE nid = 115
0.62 1 SELECT * FROM signup WHERE nid = 99
0.62 1 SELECT * FROM signup WHERE nid = 98
0.62 1 SELECT * FROM signup WHERE nid = 97
0.61 1 SELECT * FROM files WHERE nid = 99
0.61 1 SELECT * FROM files WHERE nid = 87
0.58 1 SELECT * FROM files WHERE nid = 98
0.57 1 SELECT * FROM files WHERE nid = 97
0.56 1 SELECT * FROM files WHERE nid = 96
More information about the development
mailing list