When would I need to create an index on the Semarchy back-end database tables, to improve performance (such as matching)? Upon which tables should I create those indexes?
Best Answer
C
Cédric BLANC
said
over 2 years ago
First of all, you need to identify the precise step / request that need to be improved. You can export the job log (en Application Builder / Management / Execution for example) and identify the step(s) to improve.
Once the step(s) is identified, you can find the sql order executed by Semarchy for this step (browsing execution -> specific step -> Task Definition -> SQL Statement and analyze it with a Database admin to define how to improve it : define the index you need, optimize statics computation, review a matching rule algorithm, ...
If you need an index : you can add manually directly the index on the database and validate that your performance are improved.
But WARNING : This link of components (index creation script) will not be manage by Semarchy deployment, so be careful to include it into your delivery package !
1 Comment
Cédric BLANC
said
over 2 years ago
Answer
First of all, you need to identify the precise step / request that need to be improved. You can export the job log (en Application Builder / Management / Execution for example) and identify the step(s) to improve.
Once the step(s) is identified, you can find the sql order executed by Semarchy for this step (browsing execution -> specific step -> Task Definition -> SQL Statement and analyze it with a Database admin to define how to improve it : define the index you need, optimize statics computation, review a matching rule algorithm, ...
If you need an index : you can add manually directly the index on the database and validate that your performance are improved.
But WARNING : This link of components (index creation script) will not be manage by Semarchy deployment, so be careful to include it into your delivery package !
Cédric BLANC
When would I need to create an index on the Semarchy back-end database tables, to improve performance (such as matching)? Upon which tables should I create those indexes?
First of all, you need to identify the precise step / request that need to be improved. You can export the job log (en Application Builder / Management / Execution for example) and identify the step(s) to improve.
Once the step(s) is identified, you can find the sql order executed by Semarchy for this step (browsing execution -> specific step -> Task Definition -> SQL Statement and analyze it with a Database admin to define how to improve it : define the index you need, optimize statics computation, review a matching rule algorithm, ...
If you need an index : you can add manually directly the index on the database and validate that your performance are improved.
But WARNING : This link of components (index creation script) will not be manage by Semarchy deployment, so be careful to include it into your delivery package !
Cédric BLANC
First of all, you need to identify the precise step / request that need to be improved. You can export the job log (en Application Builder / Management / Execution for example) and identify the step(s) to improve.
Once the step(s) is identified, you can find the sql order executed by Semarchy for this step (browsing execution -> specific step -> Task Definition -> SQL Statement and analyze it with a Database admin to define how to improve it : define the index you need, optimize statics computation, review a matching rule algorithm, ...
If you need an index : you can add manually directly the index on the database and validate that your performance are improved.
But WARNING : This link of components (index creation script) will not be manage by Semarchy deployment, so be careful to include it into your delivery package !
-
Deployment History Date
-
Username in Tomcat Access Logs
-
Is It Possible to Perform Automatic Authentication with The User's Windows Account?
-
Where is the documentation for Version 5.2.5?
-
On Prem Semarchy Authentication using Azure AD?
-
Delete old models
-
Sync production model version with dev
-
Recreate a dev environment. Any side effect?
-
What logging technology is used in the Semarchy xDM platform?
See all 59 topics