Super Slow Form (over 1 minute to load)

[jenniferspnc]

I’ve constantly struggled with speed in any database I’ve created (after the
split). I’ve not grasped how to implement the suggestions to improve
performance (speed). And yes, I’ve read at
http://www.granite.ab.ca/access/performanceforms.htm. I do know I have a
persistent connection (first thing I checked).

I’m hoping someone can help me with what to do for the technique that
suggests removing RecordSource and RowSource properties of forms, subforms,
comboboxes, etc. It says to load in the Form_Load event of the form.

So I can “see†how this would be implemented would someone take a look at my
SQL below and tell me how to go about “redoing†this to put into the Form
Load event.

Here is the SQL for the RecordSource of my form
SELECT Opportunity.Opportunity_ID, Opportunity.Client_ID,
Opportunity.Date_Today, Opportunity.Business_Segement, Opportunity.Source,
Approver.Approved_by, Opportunity.[Opportunity Details], Opportunity.Status,
Opportunity.Opportunity_Value, Opportunity.GP, Opportunity.Timeframe_Months,
Opportunity.Approval_ID, Opportunity.Client_Type
FROM Client_Name INNER JOIN (Approver RIGHT JOIN Opportunity ON
Approver.Approval_ID = Opportunity.Approval_ID) ON Client_Name.Client_ID =
Opportunity.Client_ID;

And here is the RowSource for one of my comboboxes:
SELECT [Client_Name].[Client_ID], [Client_Name].[Client_Name] FROM
Client_Name ORDER BY [Client_Name];

And Row Source for a drop-down box:
"Corp";"New Business";"Emergingâ€

I have several more but I’m just needing to see how it would work with the
above and then I will be able to better understand and implement the
remainder.

Thanks again!

 

[KARL DEWEY]

Try this --
FROM (Approver RIGHT JOIN Opportunity ON Approver.Approval_ID =
Opportunity.Approval_ID);

 

[jenniferspnc]

Karl,

Thank you, that did shave some time off when the form loads!

It's now around 35 seconds load and hoping to improve a bit more...any other
suggestions? In the interim I'll do more reading and testing in hopes I can
understand.

Thanks again,

Try this --
FROM (Approver RIGHT JOIN Opportunity ON Approver.Approval_ID =
Opportunity.Approval_ID);

--
Build a little, test a little.

I’ve constantly struggled with speed in any database I’ve created (after the
split). I’ve not grasped how to implement the suggestions to improve
performance (speed). And yes, I’ve read at
http://www.granite.ab.ca/access/performanceforms.htm. I do know I have a
persistent connection (first thing I checked).

I’m hoping someone can help me with what to do for the technique that
suggests removing RecordSource and RowSource properties of forms, subforms,
comboboxes, etc. It says to load in the Form_Load event of the form.

So I can “see†how this would be implemented would someone take a look at my
SQL below and tell me how to go about “redoing†this to put into the Form
Load event.

Here is the SQL for the RecordSource of my form
SELECT Opportunity.Opportunity_ID, Opportunity.Client_ID,
Opportunity.Date_Today, Opportunity.Business_Segement, Opportunity.Source,
Approver.Approved_by, Opportunity.[Opportunity Details], Opportunity.Status,
Opportunity.Opportunity_Value, Opportunity.GP, Opportunity.Timeframe_Months,
Opportunity.Approval_ID, Opportunity.Client_Type
FROM Client_Name INNER JOIN (Approver RIGHT JOIN Opportunity ON
Approver.Approval_ID = Opportunity.Approval_ID) ON Client_Name.Client_ID =
Opportunity.Client_ID;

And here is the RowSource for one of my comboboxes:
SELECT [Client_Name].[Client_ID], [Client_Name].[Client_Name] FROM
Client_Name ORDER BY [Client_Name];

And Row Source for a drop-down box:
"Corp";"New Business";"Emergingâ€

I have several more but I’m just needing to see how it would work with the
above and then I will be able to better understand and implement the
remainder.

Thanks again!