D
dmu
Can someone point me to some good books/references specifically on improving
performance? We're using SQL Server 2000 and Access 2000, Windows 200
network. We use Active Directory for our SQL security. Our SQL server used
to be in another location with which we had a direct T1 connection to. It
has now been moved to another location, on another domain with a trust
relationship to our domain, and performance on my ades has deteriorated.
Some of the questions I'm starting with are:
How do combo and list boxes affect performance? On some forms I have
several combo boxes with Select statements (some from other tables than the
form is based on, some from the same table) as their Row sources.
How do subforms affect performance? I have some subforms I created that get
reused in multiple forms, though in a few cases the subform is based on the
same table as the parent form. I like the convenience of only having to
update a subform once instead of hunting down all the occurrences of that
group of data but maybe that's not the right answer.
I've seen mention of limiting records retrieved. I'm unclear if opening a
form with DoCmd.OpenForm "frmComplaint", , , "[ComplaintID] = " &
Me.lstName, , acDialog limits the actual records pulled from the server or
just limits the display to the one record. Same with reports. Does opening
a report with DoCmd.OpenReport strReport, acViewPreview, , "[ComplaintID] =
" & Me.lstName limit the records pulled from the server?
I've also seen mention of setting forms properties to data entry. Does
opening a form with DoCmd.OpenForm "frmComplaint", , , , acFormAdd, acDialog
do the same thing? Or should I still set the form property to data entry.
I use the same form for displaying data as well as data input.
Other things I can consider? I think I got pretty good at working out *a*
solution for our needs, without learning whether or not that solution was
the best way. Hoping I don't have to re-learn everything!
Thanks!
-dmu
performance? We're using SQL Server 2000 and Access 2000, Windows 200
network. We use Active Directory for our SQL security. Our SQL server used
to be in another location with which we had a direct T1 connection to. It
has now been moved to another location, on another domain with a trust
relationship to our domain, and performance on my ades has deteriorated.
Some of the questions I'm starting with are:
How do combo and list boxes affect performance? On some forms I have
several combo boxes with Select statements (some from other tables than the
form is based on, some from the same table) as their Row sources.
How do subforms affect performance? I have some subforms I created that get
reused in multiple forms, though in a few cases the subform is based on the
same table as the parent form. I like the convenience of only having to
update a subform once instead of hunting down all the occurrences of that
group of data but maybe that's not the right answer.
I've seen mention of limiting records retrieved. I'm unclear if opening a
form with DoCmd.OpenForm "frmComplaint", , , "[ComplaintID] = " &
Me.lstName, , acDialog limits the actual records pulled from the server or
just limits the display to the one record. Same with reports. Does opening
a report with DoCmd.OpenReport strReport, acViewPreview, , "[ComplaintID] =
" & Me.lstName limit the records pulled from the server?
I've also seen mention of setting forms properties to data entry. Does
opening a form with DoCmd.OpenForm "frmComplaint", , , , acFormAdd, acDialog
do the same thing? Or should I still set the form property to data entry.
I use the same form for displaying data as well as data input.
Other things I can consider? I think I got pretty good at working out *a*
solution for our needs, without learning whether or not that solution was
the best way. Hoping I don't have to re-learn everything!
Thanks!
-dmu