10 Replies Latest reply: Jun 4, 2014 10:29 AM by Marcus Sommer RSS

    Performance issues - Slow load of document



      I have a SourceDocument which contains 220 million rows and has a size of 11GB (None compression)


      This document is splitted out into almost 75 Document files, which one user only has access to.


      This means the largest document i have is approx on 1gb - Most of them are on 100mb or so - And my expressions are not that complex.


      But when the user wants to see the documents they are acting really slow - Too slow in my opinion.


      My server specs are:

      132GB ram

      12 CORE AMD Opterib 2.1ghz

      64bit Windows 2008 R2 server


      What can be done?