T
Thomas Kroljic
All,
I am looking at ways to speed up the amount of time it takes my
forms to open.
There are two forms in particular that I would like to increase in speed.
The first is form is a listing of all the customers that a user has access
to. This form contains a subform. The subform has a query assigned to it.
The query does have a where clause that also includes a "In (select * .)"
within the where clause that filters the records from the table (in this
case the Customer table) using the empid. The Customer table has over 18,000
records. Since I have admin access, I get to see all the records. So with my
user id, it takes just over 3 seconds for this form to display the records.
I initial only display four columns of info, but the user has the option of
display other columns once the data is display.
It seems that if I open the application, I get an initial hit of about 8-10
seconds for this form to open. After which it only takes 3 or 4 seconds to
open.
I guess I'm looking to see if I can decrease the amount of time it takes to
open this form.
Any suggestion would be well received.
I'm using Access 2000. My application is separated into two databases: one
for data only, the other for all forms, reports, queries.
Thank you,
Thomas J. Kroljic
I am looking at ways to speed up the amount of time it takes my
forms to open.
There are two forms in particular that I would like to increase in speed.
The first is form is a listing of all the customers that a user has access
to. This form contains a subform. The subform has a query assigned to it.
The query does have a where clause that also includes a "In (select * .)"
within the where clause that filters the records from the table (in this
case the Customer table) using the empid. The Customer table has over 18,000
records. Since I have admin access, I get to see all the records. So with my
user id, it takes just over 3 seconds for this form to display the records.
I initial only display four columns of info, but the user has the option of
display other columns once the data is display.
It seems that if I open the application, I get an initial hit of about 8-10
seconds for this form to open. After which it only takes 3 or 4 seconds to
open.
I guess I'm looking to see if I can decrease the amount of time it takes to
open this form.
Any suggestion would be well received.
I'm using Access 2000. My application is separated into two databases: one
for data only, the other for all forms, reports, queries.
Thank you,
Thomas J. Kroljic