I'm loading 4 million rows from oracle into a dataset. I find that the size of the dataset files tends to be 10s of Gigs but when I load the same data into a loojup fileset of simple a fileset its Megs.
The load to the dataset aborts due to a space issue, but I estimate that it would require 80gb for the 4 million rows.
Any explanation would be appreciated.
Dataset Size
Moderators: chulett, rschirm, roy
Are your VarChar() columns bounded or unbounded? Using unbounded strings will save space, at a cost of performance.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>