Any idea about speeding up the load time of a form?

In my application, I have noticed that certain forms take quite awhile to display the first time during an application session, but then act responsively when the same form is requested later in the session. Of course, after the application is shut down and re-opened, it again takes a very long time to display the form.

For instance, I have a "Transactions" Form, which takes an unimaginably long time to display (nearly 10 minutes), and when I check the debuglog, it lists 2000 lines of database queries:

RdbKey: [default] Sql: select * from "dbo"."FinancialTransaction"
RdbKey: [default] Sql: select * from "dbo"."TransactionLineItem" where ((1 = 0))
RdbKey: [default] Sql: select * from "dbo"."TransactionLineItem" where ("dbo"."TransactionLineItem"."TransactionREF" in (?)) Params: v0=00165662-a9be-4900-84eb-3b2ee391349e
RdbKey: [default] Sql: select * from "dbo"."EventTicketSale" where ((1 = 0))
RdbKey: [default] Sql: select * from "dbo"."EventTicketSale" where ("dbo"."EventTicketSale"."TransactionLineItemREF" in (?)) Params: v0=56e4a6d4-a73f-4a1d-8eb8-459b098f6877
RdbKey: [default] Sql: select * from "dbo"."Payment" where ((1 = 0))
RdbKey: [default] Sql: select * from "dbo"."Payment" where ("dbo"."Payment"."TransactionREF" in (?)) Params: v0=00165662-a9be-4900-84eb-3b2ee391349e
RdbKey: [default] Sql: select * from "dbo"."HouseholdBusiness" where ((1 = 0))
RdbKey: [default] Sql: select * from "dbo"."HouseholdBusiness" where ("dbo"."HouseholdBusiness"."HouseholdBusinessGUID"=?) Params: v0=dfecf0d1-84f8-470a-97d6-e1c6ae121c07
RdbKey: [default] Sql: select * from "dbo"."TransactionLineItem" where ("dbo"."TransactionLineItem"."TransactionREF" in (?)) Params: v0=8253ad0f-a3a0-44a3-ae56-7214fd358cfb
RdbKey: [default] Sql: select * from "dbo"."TransactionLineItem" where ("dbo"."TransactionLineItem"."TransactionREF" in (?)) Params: v0=ffa1380b-c33f-46ea-8d28-4a528865e113
RdbKey: [default] Sql: select * from "dbo"."HouseholdBusiness" where ("dbo"."HouseholdBusiness"."HouseholdBusinessGUID"=?) Params: v0=48f53d40-1eff-4a5f-9788-18e9246dc5f9
RdbKey: [default] Sql: select * from "dbo"."TransactionLineItem" where ("dbo"."TransactionLineItem"."TransactionREF" in (?)) Params: v0=0018c8c4-b615-4c6e-9120-167fd8dc369c
RdbKey: [default] Sql: select * from "dbo"."HouseholdBusiness" where ("dbo"."HouseholdBusiness"."HouseholdBusinessGUID"=?) Params: v0=bcddfc9d-6fc1-4a62-a72c-ca92f7e85219

Does anyone have any insight into this? Specifically, I would love to know if there is some way I can speed up the form display and possible "pre-load" the form (on a different thread) when the application starts, so when the user requests the form, it displays quickly. 

Right now I have this code running in the Shell application (on app start):
(entityTypes is a list of a few of the entity types in my application which seem to be the slow-loading form entities)

/// <summary>Get all Entities of Types in a list into the PM asynchronously</summary>
        /// <param name="entityType">The list of Types to get entities of</param>
        public static void GetDataAsync(IEnumerable<Type> entityTypes)
        {
            string TypeName;
            string Token;

            foreach (Type type in entityTypes)
            {
                TypeName = type.Name;
                Token = TypeName + "_Complete";

                RdbQuery ASQuery = new RdbQuery(type);

                MainPm.Manager.GetEntitiesAsync(ASQuery, QueryStrategy.Normal, Token);

                DebugFns.WriteLine("FI_CODE: GetDataAsync() " + TypeName + " Completed (" + Token + ")");
            }
        }

Is there something else I should be doing?

Thanks in advance!

Heather

Edited by HFloyd - 09-Jan-2009 at 12:48pm