Performance Nightmare with a lot of fields

i tested other thing. deleting around 30 nodes takes...minutes

another test

mysql> show processlist;
+------+------+-----------+----------------+---------+------+----------------------+-------------------------------------------------------------------------------------
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------+----------------+---------+------+----------------------+-------------------------------------------------------------------------------------
| 2808 | root | localhost | suite_test | Query | 0 | NULL | show processlist |
| 2835 | root | localhost | suite_test | Query | 0 | Copying to tmp table | SELECT DISTINCT field_data_field_woerter_fc0.entity_type AS entity_type, field_data_field_woerter_fc |
+------+------+-----------+----------------+---------+------+----------------------+-------------------------------------------------------------------------------------

Copying to tmp table is now running for 10 Minutes ....the field_data_field_woerter_fc has 300.000 rows.

#1839744: Add index on {$field_collection_field}_revision_id column pretty strong boost with a lot of rows, here > 300.000

Better Performance with caching

Views: Display Cache
http://drupal.org/sandbox/Caseledde/1970904
Great if you filter nodes with an exposed field.

Pre cache entity cache:
http://drupal.org/project/drush_ecl

I hacked drush_ecl to also pre generate display_caches, will post it to the isue queue of http://drupal.org/sandbox/Caseledde/1970904 when ready