Ok, can the table and query design in this article actually scale to millions of rows ? With hundreds of concurrent queries ? I have generally become a skeptic

Ok, can the table and query design in this article actually scale to millions of rows ? With hundreds of concurrent queries ? I have generally become a skeptic of doing anything fancy on a RDBMS.