Melissa said:
My program is running very slowly with 914 patient
records. I have been wanting to add linked pics in
record form. What do you suggest so that the program
doesn't run so slow. How do I change the cache in Access-
perhaps increase my virtual memory to allocate more for
Access.
First of all, your operating system manages memory, not Access, unless
I misunderstand.
But before looking to that, I would first consider the design of your
main forms. For example, if you have a Patient form that is bound at
startup to an unrestricted query (all 914 records), that is a very
common design practice (flaw?) and probably does more to diminish
performance and resources than anything. How often do you need all 914
records loaded into memory for viewing/updating? Also, the number and
types of controls used on a single form can impact performance.
Another practice some developers subscribe to is avoiding 'embedded'
SQL record sources for forms and controls and use stored queries
instead, which avoids having to parse, check and compile queries on
the fly...
Last, I'm assuming you use a split database design (front
end-application, UI / back end-data store) and compact both on a
regular basis.
kz
