Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I am using ADO
>>
>>I have sometime a table of 4000 records how needs to be added to another table
>>
>>It is possible that one off the records already exits in that table.
>>In that case i have to replace it
>>
>>Now i first check if the record exit if not i append it.
>>Because it are all sub calls, it take a lot off time.
>>
>>Does someone have an idee to speed this up
>>
>>Kind regards
>>
>>
>>Jan Dorresteijn
>
>The first thing I would suggest is to start by only getting the records that exist in one table and not the other, so you don't have to check for existence on each record.
Thanks for your reply but the table are from different database containers
so i can not select using one statement
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement