Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2003 Server
>>Hi Mike,
>>
>>>There is a differnce in the write speed and read speed. The write takes pace about 3 times faster than the read.
>>
>>That's unusual. Normally, it's the write operation that is slower than the read, especially with transactions being involved. Do you have any columns that are memo fields or character fields with more than 254 characters that are not needed in the conversion? If so, you should replace SELECT * with SELECT field list and omit these fields.
>
>
>Can do events have an impact...
>If I run the code with do events in the loop, it executes faster as well. (But still quite slow... i.e. the speed improvement is in minutes...)
>
>There must be a way to speed this up...
>
>Transferring 27,000 records is taking about 2 hours... There is no way I will be able to transfer all the data on a weekend at this rate.
Maybe you should show us the code.
As I said earlier, such a transfer should take seconds, not minutes.
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