DB as oracle…some of my preliminary observations -
- As started working on reports on upon db server, my development team facing speed issue as they are also working upon another part of development within same database.
- As I load dashboard when I login the metabase, it start processing reports (may be compiling the reports). If I built question using native query, usually it may involve more than 2-3 tables. These questions do appear on my dashboard as my client may need them.
My questions are
a. If the questions are compiled on every start or refresh(auto) then do the tables concerned gets locked for that time (my data contains more than 100k rows/records approx for transaction tables) ?
b. Do the performance in future, I mean transactions performed by the users of the system will experience this problem if i created multiple dashboards and they are loaded by their supervisors within office hours(fixed time frame) …?
And will it be faced by supervisors of the system who use their dashboard for analysis purpose?