We are facing a performance issue when sharing our files on Access point . I want to ask , is this because of the size of qvw files we are sharing on Access points or something to do with the Data model? For example , we are sharing a qvw file 2 gb big .when someone try to open it , it takes about 10 mins.Is there anything we can do in QVS web server to optimize or reduce the opening time on access point ??
and the other scenario is if we have data model with only two tables each having size of 5 gb.and we need all the data so cannot perform silicing to achieve correct results based on our calculations.What we should do in that case?
Have you tried preloading the document on the server to make sure it's loaded in RAM at all times. This should speed up client access on initial opening.
I would also recommend going through the document using the various techniques you can find around these forums and check for potential performance problems in your data model and front end.
