Sounds like the server is re-caching on changes. Go into
the admin tool, click on File->Server Info, on the config
tab ensure that "Development Cache Mode" is clicked during
your changes. It should improve performance. When you
have completed your development, turn this option off.
Terry
On Wed, 22 Nov 2006 10:29:28 -0600
"Grooms, Frederick W" <[EMAIL PROTECTED]> wrote:
You didn't specify what database you are connecting to,
so I am making a
guess...
It may be that your db server is caching the data in
it's memory so the
first save takes some time to get the data from the
disk. Secondary
updates already have the current data for the filter in
memory so it is
quicker. After using the User Tool the filter is no
longer in the DB
server's memory so an update afterwards has to re-get
the data from the
disk
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Runar Helle
Sent: Wednesday, November 22, 2006 9:18 AM
To: [email protected]
Subject: Administrator - Performance Issues when saving
form
Hi, all
I've got a question about performance in AR
Administrator.
The performance varies for each time I save. Sometimes
it takes up to 25
seconds to save a filter, other times only half a
second. We are talking
about the same filter, and the change could be as small
as changing a
character to its name (add or remove. Makes no
difference)
The interesting thing is that it seems to be very slow
the first time I
save the filter. If I make an other change, save is
quick. And if I make
yet an other change it is also very quick. If I then
turn to the user
tool and do *any* operation that does an API/SQL call to
the server, it
all breaks down again. The first time I save anything in
the admin tool
after touching the user tool, things are sloooooow.
After the first save
operation in the admin tool, subsequent saves to that
element is quick
again..... Good thing: It's consistent.
I've have checked the API&SQL log and the difference in
API-time between
the "quick" and the "slow" saves is only milliseconds.
CPU usage on
server is only 50 percent at its peak during save
operation. For the
quick saves, I can hardly register any CPU load on the
server. There is
no noticeable load on the client either.
The server is a dual 3.4 GHz with 3,5 GB RAM.
Administrator 6,3 patch 12
ARS 6.3, patch 12
Any ideas?
Best regards,
Runar
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at
www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
