What can be done to optimize database performance?
1. Don’t have too many views – each time you change/add a document Notes will need to update every appropriate view. 2. Keep views simple – more columns means more calculation. It gets worse if the columns are sorted and worse still if the columns are categorized. 3. Don’t use @Today or @Now in selection formulas – the views will never be up to date and the server will be forever recalculating them. If you need to use today’s date in a selection formula then have a background macro running each day to set an environment variable in the server’s notes.ini and reference this. 4. If you want to display compound information in a view column from multiple fields then calculate it in a hidden document field. The column should then reference this single field rather than carrying out the calculation. 5. To avoid the @DBColumns/@DBLookups used to generate keyword lists, etc.
