Cube Concurrency

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?

more ▼

asked May 26, 2010 at 12:29 PM in Default

avatar image

Dave 1
12 2 2 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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?

more ▼

answered May 27, 2010 at 07:15 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 26, 2010 at 12:29 PM

Seen: 774 times

Last Updated: May 26, 2010 at 12:29 PM

Copyright 2018 Redgate Software. Privacy Policy