I am sorry, do you think building a reverse index for a billion products fits in one machine? Is that seriously the amount of thought you put into this comment?

Your average enterprise Java backend cannot handle that.

Yeah you're 10 years out of date on that too

on what, a raspberry pi? with what db? with what indexes? with what threading strategy? with what...

and it doesn't need to, so why would that matter?