bfuchs
asked on
ms access/sql performance question
hi experts,
I just want to verify if when having a control in a form based on dcount(*) of a view, is it ok to use a view that already exists, although it has additional tables /fields that are not necessary in this case, or is better for performance to create a new view on the server just containing the tables/fields necessary for each occasion?
I am using Sql BE and MS Access ADP FE
I just want to verify if when having a control in a form based on dcount(*) of a view, is it ok to use a view that already exists, although it has additional tables /fields that are not necessary in this case, or is better for performance to create a new view on the server just containing the tables/fields necessary for each occasion?
I am using Sql BE and MS Access ADP FE
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to all you experts,
@ JDettman ,
when you have a chance, please elaborate more on the SHOWPLAN and ISAMStats topics, in the sense of how to obtain them and how to use them properly.
Thanks,
Ben
@ JDettman ,
when you have a chance, please elaborate more on the SHOWPLAN and ISAMStats topics, in the sense of how to obtain them and how to use them properly.
Thanks,
Ben
Ben,
Not too many references around any more on SHOWPLAN. You can download a doc from here:
http://support.microsoft.com/kb/162701
Which covers both SHOWPLAN and ISAM Stats and how their used.
That doc is a little out of date however, so here's a thread with the keys required to turn SHOWPLAN on:
https://www.experts-exchange.com/questions/27951784/MS-Access-Jet-ShowPlan-problem-can't-find-use-showplan-out.html
ISAM Stats is built-in and always available.
There's also the Microsoft Jet Engine Programmer's Guide, which covers all this, but is now out of print. However it is still available on Amazon.
Jim.
Not too many references around any more on SHOWPLAN. You can download a doc from here:
http://support.microsoft.com/kb/162701
Which covers both SHOWPLAN and ISAM Stats and how their used.
That doc is a little out of date however, so here's a thread with the keys required to turn SHOWPLAN on:
https://www.experts-exchange.com/questions/27951784/MS-Access-Jet-ShowPlan-problem-can't-find-use-showplan-out.html
ISAM Stats is built-in and always available.
There's also the Microsoft Jet Engine Programmer's Guide, which covers all this, but is now out of print. However it is still available on Amazon.
Jim.
ASKER
Hi Jim,
Thanks for providing support to completion!
Thanks for providing support to completion!
ASKER
Thanks for the suggestion, I see you all sort of agree that is better to have a specific view, however just one more question,
In this case I want to know how many emails an employee got in the last week, should I create a view to be specific for that criteria, or is ok the view should be more general, and that can be part of the dcount() where clause, thereby gaining the option to reuse this view for different requirements in the future?