>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Out of curiosity I wrote it three different ways, one to use a remote view, one to use ADO, and one to use SPT (the update string being built on the fly). By far, SPT was the fastest, on the order of three times as fast. Furthermore, it could be started and stopped, whereas the RV-based version tried to bring down the entire result set when trying to do an update (even if opened NODATA).
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Hey Daniel. Just a question, out of my own curiousity - in the ADO approach did you use recordset or command objects? I am wondering how the use of command objects compares, performance-wise, to SPTs. I don't know, and like you, I am a little busy at the moment to begin benchmarking.....
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell