Dear community,
more than 80% of our lobby data scources based on complex IALs. Our database is in cloud.
And I am concerned about the lobby performance in the future if we have millions of data. Currently we are not live with IFS.
So I am asking for your opinion.
As i understand Lobby’s each lobby object create a query tread into the database. It is therefore very important that the queries are efficient, especially if the lobby is used by many users, many times a day.
To ensure that performance is ok, tests with data and evaluation with oracle explain plans is useful.
Insight knowledge in how that IAL’s is structured with tables and indexes can help a lot to ensure efficiency in joins. DBA can create additional assist with index discussion or adding.
Alternative could you use data mart functionality
/JE.
As i understand Lobby’s each lobby object create a query tread into the database. It is therefore very important that the queries are efficient, especially if the lobby is used by many users, many times a day.
To ensure that performance is ok, tests with data and evaluation with oracle explain plans is useful.
Insight knowledge in how that IAL’s is structured with tables and indexes can help a lot to ensure efficiency in joins. DBA can create additional assist with index discussion or adding.
Alternative could you use data mart functionality
/JE.
Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.