The performance improvement for P3
1 Used indexed collection to do the search and filter (cqengine)
2 Parallel processing (multi threading) for the dump file retrievement
3 Compress recon report and save blob into the database instead of clob and before show, unzip and show
4 Reduce the invocation and intercommuncation between the system and AC/DB
many times sql invocation against DB and the system to a few invocations on Oracle PL/SQL procedure/function
optimize the execution order (get batch result on AC/DB, collect the result in DB, and finally process them from Java)
Use the listagg instead of processing on Java side
getHolidayCount (currency,asofdate,maturityDate)
reduce the candidate size from SQL side instead of Java side (for FutureRollManager
5 Cache the query result from AC and database
No comments:
Post a Comment