Enhancing Database Performance in QuickDoc

We're continually striving to improve your experience with QuickDoc, and we value your feedback and patience. If your databases are running slowly, here are a few common reasons and ways to boost performance.

Factors That Can Slow Down Your Database

• Number of Pages: Large databases with many pages may take longer to load.

• Number of Properties: More visible properties can increase load times.

• Complex Sorts and Filters: Using sorts or filters on properties like title, text, formula, or rollup can extend load times due to the complex logic involved.

Tips to Speed Up Your Database

Avoid Overloading High-Traffic Pages

To prevent slowdowns in a large workspace, avoid placing too many inline databases (like dashboards) on high-traffic pages. Too many simultaneous views can strain your setup.

Instead, house each database on its own page. If you want to display multiple databases on one page, you can:

1. Type /linked on that page and select Linked view of a database to create a linked database.

2. Configure database views in this linked database to point to your desired source databases. Different views can target different source databases!

Using a single linked database means only one view is active at a time, reducing the load and improving performance.

Simplify Reference Chains

While formulas and rollups are powerful, complex chains can slow down your database. Simplify formulas that rely on multiple other formulas and rollups to speed up calculations.

Minimize Filters and Sorts on Formulas and Rollups

Databases filtered and sorted on formula and rollup properties may experience longer load times. Try to minimize these where possible.

Filter on Simple Properties

Filtering based on simple properties like select, multi-select, status, number, and date can improve database speed. Even with complex filters, starting with simple ones can reduce the number of pages processed, enhancing performance.

Hide Unnecessary Properties

For a more responsive database, hide properties that are less important in your view. This reduces the amount of data being processed.

Delete Unused Pages

Keep your database clean and up-to-date by removing unnecessary or duplicate pages. If deleting isn't an option, apply a filter on the Created time property to exclude older pages, significantly improving performance for large databases.

By implementing these strategies, you can ensure your QuickDoc databases run smoothly and efficiently.