hmm... we need to find a way to dynamically generate indexes to optimize back references views.

We should do this using cron, or batch API, so we don't lock the user interface at any time just for this. Indexes don't need to be created interactively.

Comments

Status:Active» Closed (won't fix)

Ahah! I've found an issue in the CCK queue that would be perfect here.

- #231453: Allow indexing columns

If that was implemented, that would be really great. Isn't it?

Status:Closed (won't fix)» Active

Let me re-open so it is more visible.

Anyone interested in this feature, please chime in. Please, test the patch in the CCK queue and provide feedback so we know it works, and then it can be committed. Thank you.

- #231453: Allow indexing columns

Title:Optimize back references views with dynamically generated indexesOptimize back references views with index for reference field

Better title, more accurate...

Status:Active» Fixed

This feature is now included in CCK itself (see previously mentioned CCK issue). It should be available in the next development snapshot.

Status:Fixed» Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.