Synchronisation avec ALM > NextGen Synchronizer > Améliorer les performances de synchronisation

Improve synchronization performance

To improve synchronization performance between Agile Manager and ALM, add indices to your ALM project schema as follows, depending on the type of database you use:

Microsoft SQL
CREATE INDEX BG_VTS_IDX ON [td].[BUG] (BG_VTS, BG_BUG_ID);
CREATE INDEX RQ_VTS_IDX ON [td].[REQ] (RQ_VTS);
CREATE INDEX RT_VTS_IDX ON [td].[REQ_TRACE] (RT_VTS);
CREATE INDEX RT_CREATION_DATE_IDX ON [td].[REQ_TRACE] (RT_CREATION_DATE);
CREATE INDEX LN_CREATION_DATE_IDX ON [td].[LINK] (LN_CREATION_DATE);
Oracle
CREATE INDEX BG_VTS_IDX ON BUG (BG_VTS, BG_BUG_ID);
CREATE INDEX RQ_VTS_IDX ON REQ (RQ_VTS);
CREATE INDEX RT_VTS_IDX ON REQ_TRACE (RT_VTS);
CREATE INDEX RT_CREATION_DATE_IDX ON REQ_TRACE (RT_CREATION_DATE);
CREATE INDEX LN_CREATION_DATE_IDX ON LINK (LN_CREATION_DATE);