Hello all:can any one provide me with tips and or reading materials for these two subjects
also I have a question ;I am developing a new database still no documents yet ,when I test my new form, while opening it takes alot of time and for a moment all hidden fields appear and then hide,it looks like as if the form needs arefresh but I did in postopen I put call uidoc.refresh also I checked automatically refresh fields in for properties
did any one had this problem before
thanks and
regards
Dalia
Subject: Archiving system ,speed up a database
Speed up the database – what do you want to know? There topic is very board and many developers could give a novel’s worth of data.
Achiving system – have you read the Help manual on this? Or are you looking for something like a 3rd party product.
TO you question, it seems you have hidden fields by a formula. Are you having these fields hidden on a conditional basis?
HTH – Cheers
Subject: RE: Archiving system ,speed up a database
Thanks Joe
I need to know any thing that is concerned with speeding up databases as I have a huge database more than 4M and I need to speed it up and that is also why Iam asking about archiving system,and yes I have read the help but all I found was that I can archive documents to another database based on time ,I need to do based on condition that I specify so if you can give me a hand it will be great ,are you archiving your documents ,how are you doing this
as for my question yes I am hiding fields based on a formula
Subject: RE: Archiving system ,speed up a database
I would look at the number of refreshes happening. If you have a field with caused the form to refresh that would slow things down.
If you have more than field doing a @DBlookup that would slow things down.
When you write 4M you mean 4 megabytes right? That does not seem big (to me).
If you have a lot of forumlas doing @Today that will slow things down too.
Archiving? I just have a simple lotusscript agent which either does a db.search or gets documents from a view. Then by looking at the document to make sure the conditions are met, I copy the document to the database using the copytodatabase method for the notesdocumentclass.
HTH – Cheers – Free feel also email me if you are stuck as you start your code. I am sure there are some examples here in the forum too.
Subject: RE: Archiving system ,speed up a database
Joe is absolutely right, @Today or @Now will take about 20 times longer than if they were absent - especially in a view. Here is what has worked as is very fast for me.
In my form I have a hidden computed field named “Archive” that is set to a default value of “No”.
I then have a scheduled agent that runs the following code on all documents and sets my “Archive” field to a value of “yes” if they have been closed for 6 months or longer using the following formula:
DateClosed := @If(Status=“Closed” & Closed=“” ; Opened ; Closed);
SixMonthsLater := @Adjust( DateClosed ; 0;6;0;0;0;0 );
DateMath := SixMonthsLater - @Now;
FIELD Archive := @If(Status!=“Closed” | DateMath > 0; “No” ; “Yes” )
(NOTE: I had code similar to above in my view selection but I could literally count to 20 before the view opened, now it opens in 1 second or less.)
Then I created an Archive view and only selected the documents that have the Archive field set to “Yes” as follows:
SELECT Form=“Call” & ArchiveForm = “No”