Anyone have some insight into this?
I have a bunch of parameterized querydefs in an Access database, which I
call from a Visual Basic application.
One particular querydef (there may be others, but I haven't identified
them), takes a relatively long time to set its parameter. I.e., for this
querydef, a line like:
MyQueryDef.Parameters("itm_id") = ItemID
takes about 1/3 second to execute, compared to < 1/10 second for the
other queries I've profiled. Other than the query itself, there is no
significant difference between the "fast" querydef.parameters calls and
the slow ones.