Hello,
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?
