CGridView performance with joined data

Yii 1.1 General Discussion
1

Hello,

While using CGridView to present some data (joined tables following this paradigm: http://www.yiiframework.com/forum/index.php?/topic/9083-solved-search-filter-of-a-relations-field-through-cgridview/) i found that the value property produces huge db workload when working with large datasets.

So i was trying to calculate these data once, store it in a array() and then use that table in the expression of the value property.

Bad thing is that the context that this expressions are executed is only aware of $row and $data. (framework/zii/widgets/grid/CGridColumn.php:renderCell():line 128)

Thoughts?

2

Anybody?

I would be more than eager to follow a better solution for representing relative data with CGridView but still that’s the only one i’ve found…