+ I have a View that lists all parents (Artist)
+ I have another View that returns a single count of Artists in a relationship with artists_product. It accepts a post_id (artist).
It works when I call it manually with a post_id; however, when I use it in the Artist Loop Item, the browser spins then goes blank. Is my "Count" view hitting the database each time? There's about 750 Artists. Is there a better way to do this?
Yes. Call the top level parent listing View, and inside its loop, passing a shortcode representing the current post ID in the loop in order to get the child count of that particular parent.
If I call the View that returns [wpv-items-count] 750 times, probably not a good use of resources