10157 : denormalized table

Question

One of my dataset-bound gantt charts has a RootNode_DataSource of a table for employee shifts.  Unfortunately this table is denormalized to the point where the name of the position the employee is in for the shift is not available in this table (only the position id).  In the grid I would like to list the position name.

Answer

I cannot see why the performance should suffer from this, other than the fact that you will do one look up for each row… If this look up includes a server round trip it will probably be slow, but that has very little to do with the GTP.NET.

I suggest that you either formulate your query so that the resulting result set contains the name in each row (join on the table with the name) or prepare a better look-up method that does not need a server roundtrip

Leave a Reply