https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/777645#M788 Hi <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/36083">@Erik_Zencos</a><BR /><BR />Thanks for the suggestion. I observe that not ALL entities are getting Indexed Incrementally. Few of them are still indexing full load. Mon, 01 Nov 2021 07:33:24 GMT avinashjha1787 2021-11-01T07:33:24Z https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/775318#M783 <P><U><STRONG>SAS VI Indexer - Performance improvement and API return</STRONG></U></P><P>&nbsp;</P><P>Hi</P><P>&nbsp;</P><P>I am triggering SVI Indexer via API call from batch mode.</P><P>&nbsp;</P><P>1. The API indexer takes a lot of time for indexing all entities and the time increases each day with new data load. How can I fine tune the performance ? Any guide on implementing Incremental Indexing ?</P><P>&nbsp;</P><P>2. Is there any way to&nbsp;capture when the indexing triggered via API call is complete, it would be helpful to trigger next job. Currently I am just using sleep function to hold the next job.</P> Wed, 20 Oct 2021 06:41:02 GMT https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/775318#M783 avinashjha1787 2021-10-20T06:41:02Z https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/775645#M784 <P>Hi&nbsp;</P> <P>1. Use this example program: ".../sas/spre/home/SASFoundation/ucmacros/amlcoresrv/fcf_post_index_etl.sas" combined with this docuentation:&nbsp;<A href="https://documentation.sas.com/doc/en/compcdc/8.2/visgatorag/n1qumm1bvz5hi5n1c6qp962o725i.htm" target="_blank">https://documentation.sas.com/doc/en/compcdc/8.2/visgatorag/n1qumm1bvz5hi5n1c6qp962o725i.htm</A>&nbsp;and you should be able to create a batch job that does an incremental update. See screenshot of a program (part of it) that I made.&nbsp;</P> <P>2. Might not be needed if you get above to work, very fast update. Otherwise you can probably make a query to the e.g. indext.dh_batch_job_execution table to query the status of the index job and trigger the next job based on the result.&nbsp;</P> <P>&nbsp;</P> <P>The Zencos team can help you if you need more guidance.&nbsp;</P> Thu, 21 Oct 2021 13:31:54 GMT https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/775645#M784 Erik_Zencos 2021-10-21T13:31:54Z https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/777645#M788 Hi <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/36083">@Erik_Zencos</a><BR /><BR />Thanks for the suggestion. I observe that not ALL entities are getting Indexed Incrementally. Few of them are still indexing full load. Mon, 01 Nov 2021 07:33:24 GMT https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/777645#M788 avinashjha1787 2021-11-01T07:33:24Z https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/778043#M789 <P>Glad I could be of help. If you have any concerns I would look at this log: root_folder/sas/viya/config/var/log/svi-indexer/default/sas-svi-indexer_xxxx.log</P> <P>or take a closer look at the tables in the postgres schema "svi_indexer".&nbsp;</P> Tue, 02 Nov 2021 22:28:06 GMT https://communities.sas.com/t5/Fraud-AML-and-Security/SAS-VI-Indexer-Performance-improvement-and-API-return/m-p/778043#M789 Erik_Zencos 2021-11-02T22:28:06Z