[SOLVED] Views, long query build time

Hello recentcoin
Thanks for your reply. I have MySQL. But can you explain me exactly why the view loads so slow? The second (problem-) query is superfast in the execution. But Views build the query very slow, i don't understand why. Because the same taxonomy field loads in the node form with normal speed. Why not in the exposed filter?

Ok, I had turned on the devel module and the problem is DrupalDatabaseCache and metatag_metatags_load_multiple (see the screenshots).

I also turned off the views cache in views settings but the same results... Is there a solution für this??

EDIT:
Oh i can't upload screenshot in this post... Then i must do this:

ms: 114.07
where: DrupalDatabaseCache::getMultiple
ops: PAO

SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN (:cids_0, :cids_1, :cids_2, :cids_3, :cids_4, :cids_5, :cids_6... and so on. until :cids_8053, :cids_8054)

ms: 23.09
Where: DrupalDatabaseCache:set
ops: PA

INSERT INTO cache_views (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)

ms: 17.55
Where: metatag_metatags_load_multiple
ops: PAO

SELECT entity_id, revision_id, language, data FROM metatag WHERE (entity_type = :type) AND (entity_id IN (:ids_0, :ids_1, :ids_2, :ids_3, :ids_4, :ids_5, :ids_6, :ids_7... and so on. until :ids_8054)) ORDER BY entity_id, revision_id

ms: 9.27
Where: DrupalDefaultEntityController::load
ops: PAO

SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, base.language AS language, base.i18n_tsid AS i18n_tsid, v.machine_name AS vocabulary_machine_name FROM taxonomy_term_data base INNER JOIN taxonomy_vocabulary v ON base.vid = v.vid WHERE (base.tid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5... and so on. until  :db_condition_placeholder_8054))

ms: 5.27
Where: node_tag_new
ops: PA

UPDATE history SET timestamp=:db_update_placeholder_0 WHERE ( (uid = :db_condition_placeholder_0) AND (nid = :db_condition_placeholder_1) )

And i find another interessting thing. i have a old backup and there it is work correctly, but i can't use this old backup...

But in the same view, the view query use:

SELECT node.title AS node_title, node.nid AS nid, node.language AS node_language, node.created AS node_created, 'node' AS field_data_field_summary_node_entity_type
FROM 
{node} node
INNER JOIN {taxonomy_index} taxonomy_index ON node.nid = taxonomy_index.nid
WHERE (( (node.status = '1') AND (node.type IN  ('initiative')) AND (node.language IN  ('de', 'und')) AND (taxonomy_index.tid IN  ('11995', '11997', '11996')) ))
ORDER BY node_created DESC
LIMIT 20 OFFSET 0

The interessting part ist the INNER JOIN part:

INNER JOIN {taxonomy_index} taxonomy_index ON node.nid = taxonomy_index.nid

My second (problem-) query in my first post NOT use this INNER JOIN... hm... but the views configuration is the same... How can tell views to use the taxonomy index?

EDIT:

Ok now i have the same query with the inner join taxonomy index, but it has also a long build time.