I received this info from GE and found it to be very helpful:
Chapter 7 of the system planning guide gives instructions: Sorry the pdf is too large to send but can be found on (the GE portal)website and does have screen shots. This can be done to speed up loading of larger charts but CANNOT be done when users are in the system
CHAPTER 7
Using the ArchiveObs tool
ArchiveObs is a Centricity Chart tool you can use to improve performance
when accessing patient charts with large amounts of observation data. The
tool limits the amount of observation data pulled from the server to the client
when opening a patient chart.
“Archiving” in this context means that certain observations do not
automatically load as part of the chart load process. Although they may not
load with the chart, archived observations can be accessed at any time for
searching and reporting purposes.
How ArchiveObs tool works
ArchiveObs tool searches the database for patient charts with observations
exceeding the maximum you set (default is 3000 observations).
When the tool encounters a chart exceeding the limit, it reduces the number
of observations pulled across to the client (nLimit default is 1000), while
making sure that a critical percentage of each observation heading is
represented.
The tool calculates the percentage by dividing the nLimit parameter by the
total number of observations. For example, if a patient has 5000 total
observations and the nLimit = 1000, the percentage is 20 percent (1000/5000).
This means that 20 percent of the most recent observations for each
observation heading are kept, and 80 percent of the observations for each
heading are marked as archived.
By default, the archiving tool maintains a minimum of six observations for
each heading as part of the chart load. The tool does not archive any
unsigned observations.
Using ArchiveObs
The ArchiveObs tool is a stored procedure in the application database called
ARCHIVE_OBS. To run it with the default parameters, in SQL Server
Management Studio, connect to your database server, click New Query, and
run this command:
execute archive_obs;
How ArchiveObs tool works 137
Using ArchiveObs 137
Tool parameters 138
System Planning and Requirements for Centricity Practice Solution
138
There is no undo function; however, you can undo the archiving by running the
following:
update obs archive=null;
Tool parameters
Although the default tool parameters are adequate for most purposes, you
can change them as follows:
Example
In this example, the archive for each patient is triggered by 2000 observations
(instead of the default 3000), and the tool reduces the number of observations
loaded to 500.
execute archive_obs@nMaxOBS=>2000, @nLimit=>500;
Posted : December 22, 2014 6:51 am