Page 1 of 1

Performance of timport vs tsql

Posted: Tue Jan 21, 2003 9:47 pm
by kevin31
To complete incremental updates to our database we need to do a mixture of INSERT and UPDATE operations. timport cannot do updates, correct? If I generate a file containing SQL statements and execute this using tsql.exe can I expect it to perform well with large data sets?

Performance of timport vs tsql

Posted: Tue Jan 21, 2003 10:25 pm
by mark
Use <timport> within vortex.There you can do whatever you want with the parsed data. And you'll avoid nasty problems trying to properly escape constants to embed into sql. Vortex also has the advantage of caching the sql statements so they don't have to be reparsed for each insert/update. See <sqlcache>.

Performance of timport vs tsql

Posted: Tue Jan 21, 2003 11:10 pm
by kevin31
So, would a good approach be to have two data files, one containing inserts and one containing updates, or could I have a flag on each row indicating whether it is to be an insert or update?

Also, can the <timport> function read unicode files? Do I need to do anything special to insert unicode data into a table? Thanks.

Performance of timport vs tsql

Posted: Wed Jan 22, 2003 12:09 pm
by mark
You could use one file with a flag field telling you how to process it.

You should be able to read and insert the unicode data as long as your timport field matching expressions are correct.