Hey folks,
General ADO question here: Is there a significant speed difference between using the Recordset.Find method on a recordset with about a dozen rows with a single key field created using .Open("SELECT * from table") and .Open("SELECT * FROM table WHERE pkey = 1111")?
I ask this in the context of a lookup table that needs to be hit up about 100 times in a big loop. Right now, everything is "Open" where I SELECT for the single key and I'm thinking of changing that if some benefit will be derived by opening the entire table all at once and using Find in the loop.
It's a big programming task and I was looking for some informed opinions first.
Thanks!
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05