I am starting a new web venture that may need to scale to a high number of users.
I am confident with the SPLA licencing for SQL Server Web edition, but want to know if I will need to factor in upgrading to Standard, Enterprise or DataCenter (pretty sure it won't be this one).
I know one shouldn't think about scaling before he needs to, but this will affect the architecture of the site and the business plan.
I know the processor limit is per physical processor, not thread, so that doesn't worry me. However some of the mirroring and backup features would worry me. Does SO rely on these features?
Could a site like Stack Overflow run on SQL Server Web? What aspects of maintenance and high availability would be impossible to achieve?