Ways to improve performance within budget constraints

- 1 minutes read - 116 words

Say in a situtation where budget is fixed, what will you do to improve system performance?

I came out several solutions to this at first, later I came out with more thoughts. I list them here for later reference.

  1. create selective indexes

  2. partition tables

  3. materialized view

  4. asynchrous processing: put non real-time operations as a job queue, spread jobs to non business hours, non peak loading time etc.

  5. externalize reports: reports are stored as soft copies to avoid queries to historical data

  6. running totals: calculating running totals in real time, spread the calculation to many places.

  7. archive and purge historical data.

  8. convert dynamic contents to static ones

  9. managed services changed based on usages

  10. optimize hotpathes in code

comments powered by Disqus