How QVD is loaded in Memory based on the size?

[lawrance]

Please explain How QVD is loaded in memory.

If I'm using 4GB RAM means What is maximum size of the QVD?

If I'm using 8GB RAM means What is maximum size of the QVD?

[Gysbert_Wassenaar]

Depends on what else your machine is doing and how much ram the OS and other tasks are using. There's no way for us to tell exactly. Obviously you won't be able to load a 8 GB qvd file into memory on a machine with only 4 GB ram. Or even a 4 GB qvd file.

[vinieme12]

I think the larger the RAM , more the data it can process at a time.

RAM size doesn't define size limit of the QVD it only affects speed of reload.

[Peter_Cammaert]

Do you mean QVD (data of a single table) or QVW (self-contained BI document)?

[Peter_Cammaert]

I'm not entirely sure that the RAM limit applies to QVDs. QVS will have a problem loading a document that is too large in memory. But more than once, QDS or QV started swapping/paging on my laptop when the RAM ceiling was reached. Eventually, "too much" data was processed as expected. It just took an awful lot of time.

Can you load QVDs in memory that require more memory than is available? Probably, but you don't want to do that more than once I guess.

[Gysbert_Wassenaar]

Ah, the page file you mean. Yeah, that may work, albeit very very slowly.