Redimming an array 1,000,000 times takes 4.63 seconds
The following question was asked at StackedOverflow.How do you redimension an array in VBA?. One response was some detailed code showing how to redim an array efficiently by doubling the number of elements. This took 0.41 seconds for a million records while redimming 1,000,000 took 4.63 records.
I don't think I've ever had over 100 elements in an array. Maybe 1,000 once or twice. And now I'm not at all concerned about efficiency while redimming.
Note that I only occasionally visit that website to answer questions. My biggest complaint is that you never know what comments or postings are new and haven't been answered. Very much unlike using a NNTP newsgroup reader rich client. But it's interesting to poke about to see what's new has been answered.
It's also interesting to read what bull**it has been spouted by folks who view Access with a lot of disdain. David W. Fenton is doing a fine job of answering such comments.