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"
