I have had miserable success in trying to get a decent response time out of
ADO, so on a whim, I did side-by-side comparisons with DAO using "Select *"
from all the tables in a JET database. I found that the number of rows of
data didn't affect performance significantly, but the number of fields in
the table did. Huh? As the number of fields increases, ADO's performance
decreases exponentially. For example, one table had 75 columns, and it took
ADO 3+ seconds (yes, seconds) to retrieve one row, whereas DAO did it in 20
ms, all other things being equal (cursor type, locking, etc).
Try it out! Is it me, or is it ADO? No comments about the 75 columns,
please - it's the customer's database and I can't redesign it.
Your comments appreciated.