Performance Optimization

This documents is under development.

NOT TO BE USED YET

---

When it comes to designing and implementing a database service, it usually goes through 3 stages:

1. Writing the code that just works, without diving into how it works or what are the implications of any particular implementation.

2. Refactoring the code and the database ...

If your system targets 1000+ concurrent connections, you will need more

As your system grows into

directions...

1. database optimizations: indexes, reliance on inner functions, normalization / de-normalization

2. Caching the data by the service

3. Use of listen/notify

4. pool size