I recently had to do a query that joined the location table to the node table on node.vid = location.eid and this caused some problems as the eid column is not keyed, Adding a key to this column sped things up quite a bit (from 1.5m to .10s). If this is how these two tables are joined then the eid column should probably be keyed to help performance.

Comments

bdragon’s picture

bdragon commented
Version: 5.x-1.x-dev » 6.x-3.x-dev
Status: Active » Closed (won't fix)

EID is dead.

bdragon’s picture

bdragon commented

Sorry, I hit the button too fast. I meant to say that EID is removed in HEAD and Location 3 will be using a join table. (I am not committing to the other branches because I don't want to break anything for production sites.