When to use live and when to use extract connection

Live can be used when-

1. You need data in real-time

2. Your source is optimized for the performance

3. You don't have a lot of data at the backend

4. Not many transformations are involved which can slow the performance

  The extract is preferred when-

1. When a database is not optimized for performance

2. You don't need data in real-time

3. Want to have great dashboard performance