Hello.
I have an autocomplete that I use MongoDB to save the records currently has about 8 million data in it.
I'm using PHP to do the MongoDB searches and I have to use regex to find the results in the database, I've created the indexes of text to make it faster but it still takes a lot of research. Before using MySQL and it took about 200ms to return the first 20 results, today with mongoDB it takes about 2s to find the same.
Does anyone know of another proper bank for this? Or can you speed up searches on MongoDB?