Download huge volume of Data in ATP Database from UI
Best approach to give user the option to download large volume of data from VBCS UI
We have data in one of the tables in oracle database. Total number of records is huge, can go up to 1 lakh. We have developed an ORDS service on top of that. User wants an option to download this huge data from UI. What is the best approach to download this data as CSV file.
We tried sample export component and called the ORSD service. But since the volume of data is huge, its taking a lot of time and making the UI very slow. Also there is a limitation on ORDS to get maximum 10K records in one call.