Hi all,
I’ve noticed recently that the HubDB queries for our blog and experiments blog appear to load very slowly.
In some instances we’re waiting for 3-4 seconds before the page loads. There aren’t many render-blocking scripts on the page that would cause this, so I’m curious if something in the implementation is off.
Here’s an example of our HubDB query for a blog page:
# $search: "{{ request.query_dict.search || ''}}"# $topics: "{{ request.query_dict.topics || ''}}"# $offset: "{{ request.query_dict.page ? (request.query_dict.page - 1) * 10 : 0}}"# $blogGroup: "{{ content.content_group_id || ''}}"# $authorPage: "{{ blog_author.id || ''}}"# $tagPage: "{{ tag || ''}}"query blogPosts($topics: [Number], $search: String, $offset: Int, $blogGroup: [String], $authorPage: [String], $tagPage: [String]) {BLOG {post_collection(limit: 10offset: $offsetorderBy: publish_date__descfilter: {name__icontains: $searchtag_ids__in: $topicsstate__eq: "Published"content_group_id__in: $blogGroupblog_author_id__in: $authorPagepost_tag_slug__in: $tagPage}) {items {blog_author {display_namebio}blog_tags {nameslug}featured_imagefeatured_image_alt_textpost_summaryurlnamepublish_datetag_ids}totalhasMore}}}
We are using query_dict for filtering on different tags, but we had been using that for a while and weren’t noticing any huge issues.
Any insights here would be much appreciated!
Thanks for your question. I hope your 20235 is off to a great start. I’d like to invite some of our community experts to the converstaion — hey