I am looking at the feasibility of using a cube as the back end to a high traffic web site.
Realistically I am going to see 20 queries per second against a 20 million row source, is this feasible?
asked
Cube Concurrency
Why a cube? What sort of queries, filtering the data in what ways, from how many servers, on what hardware, and so the questions go on....
Would a cube be better than a standard database that might benefit from some denormalisation ...
Its a big question you have asked and we dont have the full story to make detailed recommendations. No doubt someone on here would be happy to consult for you if you have a need for it to get the project done?
