processing time degradation when using Err.Clear()

[threeo]

why does Err.Clear() add so much processing time?

i've tested this in a loop. if i include the line
Err.Clear()
within my loop to clear out any errors from the previous record's processing....the processing time goes WAY WAY up.
if i comment out the Err.Clear() my times are very fast

processing times WITH Err.Clear(): without Err.Clear():
100 records: 1 second 1 second
200 records: 8 seconds 2 seconds
300 records: 41 seconds 4 seconds
400 records: 114 seconds 8 seconds
1000 records: forgetahboutit 24 seconds

 

[ca8msm]

I guess that's simply how long it takes to run that method. You could always check if an error exists before calling Err.Clear (i.e. only call it if it is necessary) as that may save you some time.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.