Year: 2018 Duration: 1 Month
APEX Application Database Refactoring for Performance
One Telecommunication Carrier was having problems regarding performance, in a application built in APEX and Oracle, we have to refactor that, increasing the performance of the application and the database.
One of the applications of a telecommunications client based on Canada, was architected under Oracle APEX for filtering call and data records from many different telecom carriers. The problem is that the tablespace of the database were huge, since everyday more 6 million records were inserted in the tables.
The project was basically refactoring the database architecture and also the application, because the tables didn’t have indexes neither partitions, and the performance of the application when filtering data was dramatically low.
Basically here I had to refactor queries following a query performance tuning pattern, create indexes, partitions, also we created intermediary tables with some predefined filters to increase the velocity that the data has retrieved to the APEX frontend.