Also consider that clustered indexes (i.e. a PK) mighl significantly slow down the insert process, especially if they are made up with several fields.
Sometimes you might get a better result by dropping and re-creating them (but if it is a PK, this might not be always possible).
On the other hand, with no index updates can be slower.

what could you try to do... uhm, I would try to :
1) Load the new records in a a staging table (with a truncate insert).
2) IF all the fields must be updated in existing records, then I would do a delete in the target table for all the keys present in the staging (you can use a mssqlrow component ot issue the command)
3)
I would just do a select insert (again with a mssqlrow) from staging to target

You also mentioned you are reading from the same database in which you are writing. If so step 1 is not mandatory, it can be obtained with a simple query

Example :


Source table (or view, or query) : SOURCE
target Table : TARGET
Primary key : ID

1) a mssqlrow that sends the following command : delete from TARGET where ID in (select ID from SOURCE)
2) a mssqlrow with the command : insert intoTARGET select * from SOURCE     (replace the * wth the appropriate field list if source and target do not share the same schema)

Hope it helps

Ciao
Francesco

Hello again,
it's true you can do some ELT simply sending out a query, but then having a tool like TOS is not helping you much in your task

Still I am pretty sure MS SQL has ELT components, see in attach the ones you probably need.

Second :
insert or update and update or insert totally make sense in cases when you need to"delta update" a table.
If this is your scenario then you probably need this kind of strategy, but be aware it requires to eventually perform multiple queries per record.
Instead, if you can manage to to have  a truncate/insert or delete/insert, you are likely to get a better performance.


Edit[ : sorry img did not upload. re submitting it]

hello Francesco,

am using update or insert as of now , tried insert or update also .

But insert or update is slower ...

ELT components in the palette is not available for MSSQL Server. 

Am not sure why this kind of performance issue is cropping up.....

Thanks
Vikram

Hi team ,

I am trying to populate data from one table to two other tables in the same DB am using Tmap to split the data. It takes a long time to read and write. 0.85 rows/s -- read from sql server
i have optimized the sql server , using indexes still speed is very slow ...

Thanks
Vikram