search

MarkdaleMGMT / frontend-app

Frontend App build using react js
2 stars 50 forks source link

optimize the design to return timely responses #111

Closed ayeshah closed 4 years ago

ayeshah commented 5 years ago

-manage connection pool size -close connections instantly -optimize functions and queries -optimize db structure

ayeshah commented 5 years ago

Approaches:

  1. Database level optimization a. manage the connection pool, close connections instantly b. put secondary columns in tables for faster searching c. 'index' columns that are used for searching

  2. Views a. create views that contain secondary info (balance)

  3. Pagination a. only fetch data that is required, store the tx in state

  4. Functional level optimization a. reduce the complexity of function b. limit queries made to the database

APIs /users/balance_history /accounts/transaction_history /fx/rates_history

ayeshah commented 5 years ago

optimize frontend