I have many views that are extremely SLOW.What are some of the less obvious reasons that can cause views to be ridiculously slow. Up to 2 minutes 15 seconds.
This view usually has ~ 3000 documents, eight columns total, five with field values, three columns with formulas:
-
@If(special_cost = 0; item_cost; special_cost)
-
@If(@IsText(InventoryActual); 0; InventoryActual) - @If(@IsText(InventoryReserved); 0; InventoryReserved)
-
_InventoryCost := @If(special_cost = 0 | @IsText(special_cost); item_cost; special_cost); _InventoryCost *(@If(@IsText(InventoryActual); 0; InventoryActual) -@If(@IsText(InventoryReserved); 0; InventoryReserved))
I have tried putting these formulas on the form itself to be calculated when the document is saved but then the values do not show up in the view. Please help
Subject: Views are very slowwwww
The values don’t show in the views now because you need to re-save all the documents in order to get them to calculate and get stored there.
Easiest way to do that is to set up a Smarticon button - sorry, that’s Toolbar Button in ND6! - and set it to the the following formula:
varResponse := @Prompt([YesNo]; “Refresh Docs”; “Do you want to re-save all the documents that you currently have ticked in this folder/view?”);
@If(varResponse = 1; @Command([ToolsRefreshSelectedDocs]); “”)
Highlight all the documents where the values aren’t showing and then hit your button.
Cheers,
Subject: RE: Views are very slowwwww
hello everybody
in my case (db 2gb), views don’t have any time dependant formula, don’t have non-static values either, but they are soooooo slow, and constantly appears the print messsage “opening…” and “rebuilding index…”
it’s a headache to work with this…could anyone help me, please i need it
many many thanks
Subject: RE: Views are very slowwwww
Hi Romulo and Jay-Paul,
There can be so many factors that can affect view performance. Many have been mentioned in this thread. Before we can find the root cause to your performance issues, can you give some more details about your view/db/environment?
First, is this view used only in Notes, only on the web, or both?
How often are the documents that match the select criteria for your views added/changed/deleted?
Do you run any scheduled agents or view actions that modifies a lot of documents at once?
How often are the view indexes in this db being updated? (can you verify how often the update task updates view indexes in this db?)
Are you rebuilding your view indexes on a dedicated drive/folder or are you using the default temp location?
How is your disk subsytem configured? What level of RAID are you using?
Do the documents in your views contain Readers fields?
What does your select formula look like for your views that are slow.
These questions are a start. Once you can answer these questions, we’ll have a better idea of how to isolate and determine the root cause of your perfromance problems.
Jack
Subject: RE: Views are very slowwwww
I started to answer all of your questions and in the process was going to list out all of the columns in the view. The first one was @NOW I knew from someone else that time commands can slow down views but did not see the command. Is there any way to show the time that the view was printed without having it show in the view?
Subject: YES!
Go to Database Properties… the printing tab. Select the clock… and it inserts the time at the top or bottom, whichever you choose!
Subject: RE: YES!
You did it Ruth! everything is working perfectly now. Thanks again.
Subject: Views are very slowwwww
what is the view selection value ? do you use @DocDescendants in the view selection, is it a categorized view ? if yes how many categories ? is the database fulltext indexed ? how many updaters tasks are running on the server ?
Subject: … and do you use Readers field in the documents?
Subject: what about this …
Putting time dependent functions in your selection formula can slow down your views a great deal …
If you use @today, @now, @username or other functions that are not a ‘constant’, then you should try to avoid them. They make the view recalculating all the time.
I got views with 20,000 documents in it, that works at a acceptable speed, on very basic PC-hardware.
PS: after you changed the formula of a computed field, you have to run an agent that effectivly recalculates each document with the altered form and save them. Otherwise you won’t notice anything in you views.
It is a very good technique tough to speed up views.