Make Code Search Fast

Question:
I have data of more than 100K rows. How do I make my search fast?

Product:
Velo, Javascript, Wix Data API

What are you trying to achieve?
My code shows a run time error, due to slow search of the database, I want to make it fast.

What have you already tried?
I am currently using wixData.filter() to filter the databases. And I don’t think it can handle 100K rows. So it would be helpful if you could suggest to me some ways to make it fast.

I have heard a concept of indexing the data, is it helpful here and if it is how to use it? Please suggest the most simple method