Hi,
The requirement is to upload 100,000+ records from CSV/Excel to a table in APEX and display the uploaded data in interactive grid. For this, there is a PL/SQL code which is taking more than 5 mins resulting in ‘Gateway timeout error’.
What are the best practices for handling large data uploads in Oracle APEX to avoid timeout errors?
Are there any specific configurations or optimizations I should consider for the database to handle high-volume data uploads?
Would it be more efficient to process the data in smaller batches, and if so, how can I implement this in APEX?
Any insights, recommendations, or examples of similar implementations would be greatly appreciated.
Thank you for your assistance!
Best regards,
Devika