Improve performance with tables with millions of rows.

[sybaris]

Hi,

I have 10 rows (contact table) to transport between 2 environments.
I made a fetch to make the first row :

<fetch>
  <entity name="contact">
    <filter>
      <condition attribute="contactid" operator="eq" value="5af85a85-567d-e911-a976-000d3ab98c85" />
    </filter>
  </entity>
</fetch>

Source have 16 millions of contacts and target have 3 millions.
When I click on preview, it takes too much time (~ 1 hour ?)
Any way to improve that ?

Regards
Sybaris