_SLOW_ QueryDef.Parameters call

_SLOW_ QueryDef.Parameters call

Post by Joel Shepher » Sat, 12 Sep 1998 04:00:00

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.

Any ideas?


1. calling access querydef that calls a user defined access function

I am using vb 4.0 and an access 2.0 database.  I need to call an access
querydef from my vb program. However this particular querydef calls an  
acccess basic function that I wrote.  When I run from access everyting
runs fine. But when I call it from vb I get an error.  Is there anyway  
around this?  

I need to call the function because it performs a function that cant be
done in sql and I dont want to embed the sql code in my vb code.

Thanks for your help.


2. Attaching/linking tables from one database to another.

3. Querydef slow

4. How to use multi-protocol?

5. Parameterized QueryDef nested in another QueryDef

6. printing char(252-255) on a printer

7. Setting querydef parameters

8. SetUser - With NoReset

9. Question for anyone who has used parameter queries in querydef objects under VB

10. Querydef: Parameter in a Order By Clause

11. Querydef, Parameters Problem