Versions des environnements
>Dmitry,
>
>Can't you get rid of buffering? Maybe that speeds up the process. Also you mentioned that the table is in the local disk, so, isn't it possible to open it exclusively for this update?
Yes, I think that EXCL would make a huge difference.
And if it is EXCL then there would be no need for buffering (unless, as I think I read, there is TRANSACTION involved) because Windows itself would cache the updates until it *had to* frre up more cache space.
It also wasn't clear if the TABLEUPDATE() is done once per mass change or on every record updated. There could be time to be saved there too.
cheers
Précédent
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