[development] Object caching

[Richard Archer]

At 4:13 PM -0500 20/7/06, George Kappel wrote:

>I have just started using Drupal but have seen issues where the existing
>database cache is a bottleneck.
>
>My menu has 5,000 items and the overhead to build it, serialize,cache in the
>db,unserialize was very high making it unuseable.
>
>The serialized menu was approx 1.9M according to the DB
>
>The workaround was to prevent the builtin caching and store the $_menu in
>APC user cache.

Do you have any figures showing the improvement from this
change? I benchmarked APC a while ago (v3.0.8) and couldn't
manage to show a significant performance increase.

Data stored in APC is also serialized and unserialized.
You're only saving the database call and with a busy site
and a well-tuned database this result should be served
from RAM.

Not to mention, you still need to build the menu when
it changes and that's where the real overhead occurs.

 ...R.