Jim,
Are you experiencing issues with reporting performance?
The report by itself will probably run faster from a recordsource of a single table however your "Made" table might not have any indexes which would slow performance if you have any sorting and grouping.
However, if you add the time it takes to make the table, I would doubt there is much to gain from making a table first. The only time I have done this is with ODBC connections to multiple tables where I could use pass-through queries as the source for local (temporary MDB) action queries. Then use the temporary tables as the record source for the report.
Duane Hookom MVP
MS Access
> To: MS_Access_Professionals@yahoogroups.com
> From: liz_ravenwood@beaerospace.com
> Date: Tue, 16 Jul 2013 18:53:06 +0000
> Subject: RE: [MS_AccessPros] Query Performance question
>
> Jim,
>
> What I do is have a subquery that has all the fields/tables/relationships you need without the criteria, and then have your vba code set the querydef.sql of an inner join query that establishes the criteria.
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
> Sent: Tuesday, July 16, 2013 9:06 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Query Performance question
>
> Hello all,
>
> I have a question about query performance.
>
> What would be faster to use for a report?
> I have several reports that are based on the same multi table query, but with different criteria across the grid. It would be almost like a View in SQL.
>
> Thank You
>
> Jim Wagner
>
> A query with 3 tables in the design view with the criteria in the grid
>
>
> OR
>
> A Make table query that has all the tables and criteria being used for the source of the report
>
>
>
>
>
> ------------------------------------
>
> 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.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar