Maximum Recommended Recordcount for a DSO

[Former Member]

I thought I'd seen some guidelines on recommendations regarding DSO recordcounts ... but I can't seem to find them at the moment.

We generally load from a PSA to DSO, and then into partitioned cubes. In this scenario the DSO continues to grow, and after a few years I'm wondering when big is too big? I don't see any load issues yet, but it would seem like that day is inevitable!

[Former Member · Accepted solution]

"For DataStore objects, we recommend that you do not save more than 20 million data records. Otherwise the activation process takes considerably longer. For InfoCubes, we recommend that you do not save more than 200-400 million data records. Otherwise the compression and reconstruction of aggregates takes too long. The semantically partitioned object does not have these implicit restrictions, as the data quantity is distributed between several data containers."- help.sap.com

http://help.sap.com/saphelp_nw73/helpdata/en/d1/468956248e4d9ca351896d54ab3a78/frameset.htm

[ThomasEsser · Accepted solution]

Where do this values come from? 20 Mio. records for a DSO?