Liz
Each DLookup is like a mini-DAO recordset so if you are opening 4 sets as opposed to one, the recordset wins out. As to a real measurable comparison, it depends more on the size of the table and how well-indexed it is.
Bill Mosca
--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> AH. I just read that DAO is 25% faster.
>
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
> Sent: Wednesday, September 05, 2012 9:54 AM
> To: 'MS_Access_Professionals@yahoogroups.com'
> Subject: [MS_AccessPros] dlookup vs dao recordset
>
> Pros, which is better, a dao recordset and setting unbound fields or 4 dlookups?
>
> Liz Ravenwood
> Programmer/Analyst
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
Tidak ada komentar:
Posting Komentar