Besides the basic issue discussed in http://drupal.org/node/112681 and http://drupal.org/node/192951, two directions for performance improvements have been identified for ZG:

  • module-level control of block caching
  • adding an index on the "ts" field of the ZG table

Caching appears to be valuable on the "Top searches" block, which evolves more slowly, but less so on the "Latest n" block, which by definition needs fresh data.

The attached patch fixes the index part of this issue. Use update.php after applying it.

CommentFileSizeAuthor
#1 zg193276-1.patch15.9 KBfgm
#1 zg193276-1.patch15.9 KBfgm
zeitgeist.install.patch1.12 KBfgm

Comments

fgm’s picture

fgm
Primary language French
Location Paris, France
commented
Version: 6.x-1.x-dev » 5.x-1.x-dev
Status: Active » Needs review
StatusFileSize
new zg193276-1.patch15.9 KB
new zg193276-1.patch15.9 KB

New patch integrates the ts index, caching for ZG blocks, and a revamped settings page.

fgm’s picture

fgm
Primary language French
Location Paris, France
commented
Status: Needs review » Fixed

Included in today's version.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.