Performance problem with insert in TD 13.0

Database
N/A

Performance problem with insert in TD 13.0

Hi,

I'm testing a query of TVA in TD 13.0, it's an insert-select over a tabla type SET (32 bytes for record).

The query are always running, more than one day...

I try the same as MULTISELECT and insert the 13.000.000 of records in some as 1 minute !!!

Exists some configuration for make a best performance in TD 13.0 ?

Regards.
1 REPLY
N/A

Re: Performance problem with insert in TD 13.0

Yes - define a usable primary index on the target table.
If the primary index on the target has very few values, insert to a Set table will be very slow. Inset to a Multiset table is MUCH quicker because it does not have to check previously stored rows with the same PI value.
If you have not specified a PI on the target table, it uses the first column.