Re: [Virtuoso-users] estimating NumberOfBuffers

2015-04-23 Thread Andy Jenkinson
Thank you that is very helpful. Cheers, Andy > On 23 Apr 2015, at 03:46, Hugh Williams wrote: > > Hi Andy, > > The amount of memory and hence NumberOfBuffers a dataset requires for being > hosted/cached in memory for best performance varies depending on how well a > given dataset can be comp

Re: [Virtuoso-users] estimating NumberOfBuffers

2015-04-22 Thread Hugh Williams
Hi Andy, The amount of memory and hence NumberOfBuffers a dataset requires for being hosted/cached in memory for best performance varies depending on how well a given dataset can be compressed, which varies based on its structure (data regularity) and size of literals etc. and thus makes this h

[Virtuoso-users] estimating NumberOfBuffers

2015-04-22 Thread Andy Jenkinson
Hi, I would like to find a more efficient way to work out how much memory to allocate to some new Virtuoso VMs, which is directly dependent on how many buffers I allocate to Virtuoso. I want to allocate enough memory so that the column store is effectively operating in-memory. To work this out,