Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
performance of SQL statement vs query
- Thread starter Coban
- Start date
Ari,
If you save the query either as a query object or in the recordsource property of a form or a report, Jet will build a query plan the first time it is used, speeding performance on subsequent uses. A bit. If you do it in code, the plan has to be built every time the query is used. In most cases the difference is pretty small. In some cases I'll be willing to suffer a bigger hit because it gives me the ability to build the sql on the fly, in the code.
Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995
Take a look at the Developer's section of the site for some helpful fundamentals.
If you save the query either as a query object or in the recordsource property of a form or a report, Jet will build a query plan the first time it is used, speeding performance on subsequent uses. A bit. If you do it in code, the plan has to be built every time the query is used. In most cases the difference is pretty small. In some cases I'll be willing to suffer a bigger hit because it gives me the ability to build the sql on the fly, in the code.
Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995
Take a look at the Developer's section of the site for some helpful fundamentals.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question