Re: Exporting to excel with high data with high volume
Are you using the IE Plugin client or the Ajax Client?
there is a bug in QV11 SR1 related to "slow exports to excel" that was supposedly corrected for SR2 so that might be a thing to check into (it was listed in the release notes).
The IE Plugin generates the export client side while the Ajax client triggers the server to generate the xls file in a folder on the server and then push the link to the client once done.
The spreadsheet is first created on the server and then moved to the client. However, this was not designed for large amount of data and the amount of data will vary based on your environment. You can add the below to the QVS settings.ini file to tell when to change over to CVS and that might help you..The default is 65500 and you would have to add it. I would set it low so it will start off as CVS..