Better way to get tag stats?

I have over 4000 posts. I am trying to query all the posts and get the count of tags each post has and sum up posts count based on number of tags the post has in dashboard. The posts count shows up properly when post_per_page is less than 2000 but beyond 2000 , the query timesout . It just shows ‘0’ for all.

Show certain terms from custom taxonomy but exclude ‘parent’ terms?

I have a custom post type “mycustom_products” (hierarchical) that has custom taxonomies called ‘categories’ and ‘tags’ (as many other custom post types do). My custom category is called “myprod_category” (also hierarchical) and my tag taxonomy is called “product_tag” (not hierarchical).

tag search using WP_Query

I need to find only posts with a tag forest gump. I’ve tried: new WP_Query('tag=forest+gump');, new WP_Query('tag=forest gump');. However they both return ALL the posts and not only the posts with forest gump tag. Single tags (without spaces) work fine, though. Alternatives (like plain SQL) will work as well.