Download & Extend

Table node_field_matrix_data should have indexes for perfomance

Project:Matrix field
Version:6.x-2.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

for only query that used in module it should be:
$schema['node_field_matrix_data']['primary key'] = array('vid', 'field_name');
but i recommend add one more for nid:
$schema['node_field_matrix_data']['indexes'] = array('nid' => array('nid'));

Comments

#1

Version:6.x-1.4» 6.x-2.x-dev
Status:active» fixed

Thanks for the suggestion. I've added the indexes in the latest 2.x dev version.

#2

oh, sorry, primary index should be

<?php
$schema
['node_field_matrix_data']['primary key'] = array('vid', 'field_name', 'row', 'col');
?>

#3

Status:fixed» active

#4

Status:active» fixed

I've only implemented simple indexes on nid and vid as database data integrity checking is not needed here.

#5

Status:fixed» closed (fixed)

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