# Query Taking Too much time

**URL:** <https://forum.weaviate.io/t/query-taking-too-much-time/1853>\
**Category:** Support\
**Created:** [March 29, 2024, 3:58pm UTC](https://forum.weaviate.io/t/query-taking-too-much-time/1853 "2024-03-29T15:58:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yogesh\_Sharma](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/yogesh_sharma/32/1198_2.png) [@Yogesh\_Sharma](https://forum.weaviate.io/u/Yogesh_Sharma)\
**Post date:** [March 29, 2024, 3:58pm UTC](https://forum.weaviate.io/t/query-taking-too-much-time/1853/1 "2024-03-29T15:58:36Z")

</div>

I am using weaviate version [1.24.4].  
I have a schema with properties mention below :

“properties”: [  
{  
“name”: “text”,  
“dataType”: [“text”],  
“description”: “Text chunks”,  
“tokenization”: “word”,  
},  
{  
“name”: “prop 1”,  
“dataType”: [“number”],  
“description”: “Prop 1”,  
“moduleConfig”: { # Module-specific settings  
“text2vec-transformers”: {  
“skip”: True,  
“vectorizePropertyName”: False,  
}  
},  
},  
{  
“name”: “prop 2”,  
“dataType”: [“number”],  
“description”: “Prop 2”,  
“moduleConfig”: { # Module-specific settings  
“text2vec-transformers”: {  
“skip”: True,  
“vectorizePropertyName”: False,  
}  
},  
},  
{  
“name”: “prop 3”,  
“dataType”: [“number”],  
“description”: “Prop 3”,  
“moduleConfig”: { # Module-specific settings  
“text2vec-transformers”: {  
“skip”: True,  
“vectorizePropertyName”: False,  
}  
},  
},  
{  
“name”: “prop 4”,  
“dataType”: [“number”],  
“description”: “Prop 4”,  
“moduleConfig”: { # Module-specific settings  
“text2vec-transformers”: {  
“skip”: True,  
“vectorizePropertyName”: False,  
}  
},  
},  
{  
“name”: “prop 5”,  
“dataType”: [“number”],  
“description”: “Prop 5”,  
“moduleConfig”: { # Module-specific settings  
“text2vec-transformers”: {  
“skip”: True,  
“vectorizePropertyName”: False,  
}  
},  
},  
]  
}

I need to filter on Prop 5 and do a vector search on property “text”.

My total number of records are around 30 millions. I ma using default settings and machine infra is 128 CPU and 256 GB Memory.

My query is taking around 2-3 seconds.  
Can you please help me with optimisation. Optimisation related to Schema and Weaviate Setup so that I can achieve the performance within few hundred mili seconds.

---

<div class="post-metadata">

**Author:** ![DudaNogueira](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.weaviate.io/dudanogueira/32/7846_2.png) [@DudaNogueira](https://forum.weaviate.io/u/DudaNogueira)\
**Post date:** [April 1, 2024, 4:41pm UTC](https://forum.weaviate.io/t/query-taking-too-much-time/1853/2 "2024-04-01T16:41:53Z")

</div>

Hi @Yogesh_Sharma !

Please, when opening an issue in #Support, please, answer all the questions we ask on the template, as this has proven to improve our troubleshooting.

What is the version of the client you are using? Is it multinode? Single node?

Can you share the query?

Also, do you see any outstanding logs?

THanks!