[drupal-devel] Fwd: history-table

Gerhard Killesreiter killesreiter at physik.uni-freiburg.de
Mon May 9 18:54:10 UTC 2005

On Mon, 9 May 2005, Dries Buytaert wrote:

> On 09 May 2005, at 18:55, Dries Buytaert wrote:
> > That or _forum_user_last_visit() should only load/cache information
> > about the nodes in the relevant forum (i.e. add a left join).  Even
> > so, we risk doing some work twice.  We'll need to do some profiling
> > for this ...
> I did some quick measurements.

I created an issue for this:

> 1. If one has a small history (40 rows in the history table),
> _forum_user_last_visit() is faster than node_last_viewed().
> 2. If one has a large history (550 rows in the history table),
> node_last_viewed() is slightly faster than _forum_user_last_visit().

This is 550 rows per user I assume?

> The difference is less than 10 ms but most of the time
> _forum_user_last_visit() is the fastest.  If we change the current
> behavior to tidy up or unify the code, performance is going to degrade
> slightly.  Unless, of course we can improve the performance of
> node_last_viewed().

no idea how to achieve this.


More information about the drupal-devel mailing list