I have book with 150 nodes. There is block of this book on page. With devel module I see 500+ get_book_children requests (like SELECT mlid, weight, link_title FROM z_menu_links WHERE plid = 11392 ORDER by weight, link_title). I have host limits by SQL requests count :(
Can you decrease requests count? It will be very good. Thanks

Comments

PixelClever’s picture

PixelClever commented
Status: Active » Closed (works as designed)

I suggest using block cache alter module to cache the block. This will eliminate all of those calls. http://drupal.org/project/blockcache_alter. From what I understand in D7 this capability may be added to core.

Otherwise you are welcome to present a patch that reduces sql queries as long as it does not alter the functionality in any way. Be careful though, the count has some twist and turns to it.

super_romeo’s picture

super_romeo commented

Thanks

PixelClever’s picture

PixelClever commented
Status: Closed (works as designed) » Closed (fixed)