# Queries are taking long time to execute

**URL:** <https://forum.weaviate.io/t/queries-are-taking-long-time-to-execute/177>\
**Category:** Support\
**Created:** [June 13, 2023, 1:38pm UTC](https://forum.weaviate.io/t/queries-are-taking-long-time-to-execute/177 "2023-06-13T13:38:08Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vamsi](https://avatars.discourse-cdn.com/v4/letter/v/b38774/32.png) [@vamsi](https://forum.weaviate.io/u/vamsi)\
**Post date:** [June 13, 2023, 1:38pm UTC](https://forum.weaviate.io/t/queries-are-taking-long-time-to-execute/177/1 "2023-06-13T13:38:08Z")

</div>

Hi,

We have close to 11 million objects in class `Article` and each of those objects has a `Metadata` as cross reference. Now when we try to do hybrid search on `Article` class with filters on `hasMetadata` and a vector for semantic search on `Article` it is taking on an average 30 seconds with some queries taking upto 2 minutes. is there anyway we can speed up this?

---

<div class="post-metadata">

**Author:** ![jphwang](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/jphwang/32/38_2.png) [@jphwang](https://forum.weaviate.io/u/jphwang)\
**Post date:** [June 13, 2023, 6:29pm UTC](https://forum.weaviate.io/t/queries-are-taking-long-time-to-execute/177/2 "2023-06-13T18:29:19Z")

</div>

Hi @vamsi - am I understanding that you’re filtering by cross-referenced properties? As in, properties of the cross-referenced objects?

I _think_ that’s what’s slowing you down, because each cross-reference has to be resolved for filtering, but I will confirm that with the team.

If that is the case, is it possible to build in to the `Article` class the properties that you want to search for?

---

<div class="post-metadata">

**Author:** ![antas-marcin](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/antas-marcin/32/20_2.png) [@antas-marcin](https://forum.weaviate.io/u/antas-marcin)\
**Post date:** [June 13, 2023, 6:35pm UTC](https://forum.weaviate.io/t/queries-are-taking-long-time-to-execute/177/3 "2023-06-13T18:35:01Z")

</div>

Could you also share with us which Weaviate version are you using?

---

<div class="post-metadata">

**Author:** ![vamsi](https://avatars.discourse-cdn.com/v4/letter/v/b38774/32.png) [@vamsi](https://forum.weaviate.io/u/vamsi)\
**Post date:** [June 14, 2023, 4:36am UTC](https://forum.weaviate.io/t/queries-are-taking-long-time-to-execute/177/4 "2023-06-14T04:36:05Z")

</div>

We are using v1.19.5.

---

<div class="post-metadata">

**Author:** ![vamsi](https://avatars.discourse-cdn.com/v4/letter/v/b38774/32.png) [@vamsi](https://forum.weaviate.io/u/vamsi)\
**Post date:** [June 14, 2023, 4:41am UTC](https://forum.weaviate.io/t/queries-are-taking-long-time-to-execute/177/5 "2023-06-14T04:41:39Z")

</div>

Yes. since there can be a lot of article objects with same metadata, we split into two separate classes.

The thing is there are close to 50 properties in metadata. We can’t finalize properties to search on because the use cases might change in future and we might need to filter on more properties.

---

<div class="post-metadata">

**Author:** ![Narayan\_Acharya](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/narayan_acharya/32/459_2.png) [@Narayan\_Acharya](https://forum.weaviate.io/u/Narayan_Acharya)\
**Post date:** [September 13, 2023, 4:01pm UTC](https://forum.weaviate.io/t/queries-are-taking-long-time-to-execute/177/6 "2023-09-13T16:01:27Z")

</div>

Hey @jphwang did you get a chance to check with the team why filtering by cross-referenced properties is slow and if there are any possible workarounds/resolutions for users?