Synchronize same table in different tasks

[lefjucabro]

Hi,
Thanks to DotmimSync framework I can synchronize sqlite and mysql databases.
I have a table with multiple and heavy BLOBS and when I want to synchronize them from mysql to sqlite I have a timeout message error because the request :

SELECT
	  `base`.`ID`
	, `base`.`BLOB_RECORD`
	, `base`.`TableMiddle_ID`
	, `side`.`sync_row_is_tombstone` as `sync_row_is_tombstone`
FROM `TableDest` `base`
LEFT JOIN `TableDest_tracking` `side` ON `base`.`ID` = `side`.`ID`
WHERE (
	(`side`.`timestamp` > @sync_min_timestamp or @sync_min_timestamp IS NULL)
)
UNION
SELECT
	  `side`.`ID`
	, `base`.`BLOB_RECORD`
	, `base`.`TableMiddle_ID`
	, `side`.`sync_row_is_tombstone` as `sync_row_is_tombstone`
FROM `TableDest` `base`
RIGHT JOIN `TableDest_tracking` `side` ON `base`.`ID` = `side`.`ID`
WHERE (`side`.`timestamp` > @sync_min_timestamp AND `side`.`sync_row_is_tombstone` = 1);

I would like to synchronize this table TableDest with different tasks in order to avoid the timeout error. I cannot create multiple setup filter on one table.

Here is the code that works individually to synchronize data. I want to modify this code so that I can call it several times by changing the “_WhereValueTableSrcB ” parameter in the filter request.

            var SetupFilterTmp = new SetupFilter(TableDest);

            // Ajout du paramètre de filtrage basé sur l'ID des tables Intervention/Installation
            SetupFilterTmp.AddParameter("ID_TableSrcA", "TableSrcA", false);
            SetupFilterTmp.AddParameter("ID_TableSrcB", "TableSrcB", false);

            // joint TableMiddle
            SetupFilterTmp.AddJoin(Join.Inner, "TableMiddle")
                                .On(TableDest, "TableMiddle_id", "TableMiddle", "ID");
            // joint TableSrcA
            SetupFilterTmp.AddJoin(Join.Inner, "TableSrcA")
                                .On("TableMiddle", "TableSrcA_id", "TableSrcA", "ID_TableSrcA");
            // joint TableSrcB
            SetupFilterTmp.AddJoin(Join.Inner, "TableSrcB")
                                .On("TableMiddle", "TableSrcB_id", "TableSrcB", "ID_TableSrcB");

            // Filtering
            SetupFilterTmp.AddCustomWhere("({{{TableSrcA}}}.{{{ID_TableSrcA}}} IN (" + _WhereValueTableSrcA + ") AND" +
                                                                    "{{{TableSrcB}}}.{{{ID_TableSrcB}}} IN (" + _WhereValueTableSrcB + "))" +
                                                                    " OR {{{side}}}.{{{sync_row_is_tombstone}}} = 1");

            // Add filter to sync
            _SyncSetup.Filters.Add(SetupFilterTmp);

Thank for your advices