For various reasons I carried out two sets of tests against to similar pages. One page retrieves data from only one table in the database. The other page retrieves data by bridging between several tables. The results changed from around 2ms to 40ms leaving a huge difference to be accounted for merely in the DBMS creating the joins.
If time is available (and I think it is) it will be interesting to investigate whether this result can be improved by introducing a denormalised field in the database. I suspect this to be rather easy but in reality would also require some complex logic to be executed on update (probably as a trigger).
Advertisement
