>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only