I have two QVWs running with about 35 users. Both QVWs hold in excess of 3 million rows; one is 50 MB, the other 58 MB. The way I have set these documents up means that the users don't have any issues using them (apart from them being a little slow to populate), but if I accidently create a table box with all data then I need to reboot my PC.
If I limit the load on the same QVWs they run really fast, so this got me thinking: when is a QVW too large?
Do you have a limit that you stick to?
Is there a certain number of rows that once you pass you don't see any further loss of performance?
