I have a qvw application with size 146 MB . will it creates any problem if I make vailble this file in access point. And I have Ajax Client.I need to give to five users to access this file.
My application is compressed as High and I need to have too many columns in straight and pivot tables as per business. and I have 72Gb RAM in server and only 40 GB is free. Is all this conditions will meet the application?
you may follow these steps (is just an approximation, but it can be useful):
1. Open your .qvw in desktop and change the compression high to none (Document properties > General). This way you can see the actual size of your qvw.
2. Multiply the uncompressed size of your qvw times 4 (it is roughly the size it will use in RAM).
3. Every concurrent user will add roughly 10% in RAM (so it would be the result of step 2 plus 10% RAM of original qvw for every concurrent user).
For example, let's suppose your uncompressed qvw is 500 MB:
500 MB * 4 = 2000 MB in RAM
2000 MB * .10 = 200 MB for every extra concurrent user
2000 MB + ( 200 MB * 5 Users) = 3000 MB. So your worst case would be to use almost 3 GB in RAM, if your 5 users are connected at the same time.
Like I said this is an approximation, but can give you an idea of the sizing of QV Environment,
Complementing the response by Jaime Aguilar, be carefull about tables with too many columns/rows. If your users are "Send to Excel"-Addicted you can experience poor response times
