I will have to look into this, but I want to make sure I understand your use case.
You expect to have 10k people online simultaneously hitting a query that needs to run fresh each time because each user will be inserting? Can you explain a little more about the use case? Is this a one time event that you expect a surge?