I had read on Claude that if you optimize MySQL table to 100kk rows, it will work same quick for 100kkk rows too.
I am not sure. I cannot load Manticore Search with 100kkk rows, lol :)
However I tested Manticore Search with 20kk rows and search text in it and 20 queries in the same function work in 100-200ms.
Good question. Hope one day I will get that experience(these knowledges) and compare :)
Top comments (0)