Hey Tom,
>It would be helpful to have such benchmarks posted on the UT in a place where everyone can find them.Yeah, probably ... but for now, I suppose a search on "benchmark" or "benchmarks" might get you a few hits ... although, you can't do a search unless you're PUTM, right?
~~Bonnie
>Bonnie;
>
>It would be helpful to have such benchmarks posted on the UT in a place where everyone can find them. I do see the need of large data sets that represent say 1000 records or some such number. The more records the better! Well, sort of! There has to be a practical limit. :)
>
>Tom
>
>
>>Hey Kevin,
>>
>>
>... maybe that'll be my lunchtime exercise. ;)>>
>>Go for it, dude! <g>
>>
>>~~Bonnie
>>
>>
>>
>>>Hey, Bonnie...
>>>
>>>Interesting thread, I must have missed it when it was first posted. I would have guessed DataViews to be slower, though from what you reported, it looks like they should only be used when necessary.
>>>
>>>I've never benchmarked a FIND versus other ways - I would *guess* that you'd have to have a large # of rows before you'd notice FIND being much faster - maybe that'll be my lunchtime exercise. ;)
>>>
>>>Kevin