Developer Guide
Other documentationsDemoCommunityGitHub
  • Forest Admin
  • Getting Started
    • Quick start
    • Development workflow
  • Reference Guide
    • How it works
      • Environments
      • Developing on Forest Admin
        • Using branches
        • Deploying your changes
        • Forest CLI commands
          • init
          • login
          • branch
          • switch
          • set-origin
          • push
          • environments:reset
          • environments:create
          • deploy
          • schema:diff [beta]
        • Express packages
    • Models
      • Enrich your models
      • Relationships
        • Create a Smart relationship
          • GetIdsFromRequest
        • Smart Relationship Examples
          • Smart hasMany relationship in mongoDB
    • Actions
      • Create and manage Smart Actions
        • Use a Smart Action Form
        • Use a Smart Action Intent
      • Smart Action Examples
        • Calculate the distance between two string addresses
        • Impersonate a user
        • Create a record with a multiselect through a many-to-many relationship
        • Handle enums with alias labels in a smart action
        • Dropdown with list of values in smart action form
        • Custom dynamic dropdown in a form using smart collections
        • Refresh hasMany relationship in smart action
        • Smart segment to restrict access to an action on a record details view
        • BelongsToMany edition through smart collection
        • Upload files to amazon s3
        • Upload several files with the File Picker
        • Retrieve smart field info in a smart action
        • Smart action to create several records from the input of a single smart action form
        • Add many existing records at the same time (hasMany-belongsTo relationship)
        • Call a webhook with record ids
        • Bulk update records
    • Smart Fields
      • Smart Field Examples
        • Add an HTML credit card as a smart field in a summary view
        • Display field with complex info in html format (rich text editor)
        • Generate signed urls to display S3 files in a smart field
        • Print a status object in a single line field
        • Sort by smart field
        • Sort by smart field that includes value from a belongsTo relationship
        • Add fields destined to the create form
        • Add validation to a smart field edition
        • Display smart field as progress bar using rich text editor
        • Update point geometry field using a smart field and algolia api
    • Smart Collections
      • Examples
        • Create a Smart Collection with Amazon S3
        • Smart relationship between model and stripe cards
        • Create records from a Smart collection
        • Searchable smart collection with records fetched from hubspot API
      • Serializing your records
    • Routes
      • Default routes
      • Extend a route
      • Override a route
    • Integrations
      • Stripe
      • Mixpanel
      • Intercom
      • Elasticsearch
        • Interact with your Elasticsearch data
        • Elasticsearch service/utils
        • Another example
      • Zendesk
        • Authentication, Filtering & Sorting
        • Display Zendesk tickets
        • Display Zendesk users
        • View tickets related to a user
        • Bonus: Direct link to Zendesk + change priority of a ticket
      • Dwolla
        • Display Dwolla customers
        • Display Dwolla funding sources
        • Display Dwolla transfers
        • Link users and Dwolla customers
        • Dwolla Service
      • Razorpay
      • Hubspot
        • Create a Hubspot company
        • Display Hubspot companies
      • Twilio
        • Send an SMS with Twilio and Zapier
      • Azure Table Storage
      • Slack
        • Send Smart Action notifications to Slack
      • Algolia
        • Geocode an address with Algolia
    • Smart Views
      • Create a Map view
      • Create a Calendar view
      • Create a Shipping view
      • Create a Gallery view
      • Create a custom tinder-like validation view
      • Create a dynamic calendar view for an event-booking use case
      • Create a custom moderation view
    • Smart Segments
    • Scopes
      • Create a scope more than one level away based on a Smart field
      • Scope on a smart field extracting a json's column attribute
    • Performance
    • Charts
      • Create an API-based Chart
      • Create a Smart Chart
      • Create Charts with AWS Redshift
  • Extra help
    • Setup
      • Install
      • Connecting Forest Admin to Your Database (Forest Cloud)
      • Forest Admin IP white-listing (Forest Cloud)
      • Why HTTPS is necessary even locally
      • Troubleshooting
      • Prevent permission errors at installation
      • Deploy your admin backend to AWS
      • Deploy your admin backend on Heroku
      • Deploy your admin backend to Ubuntu server
      • Deploy your admin backend to Google Cloud Platform
      • Install Forest Admin on a remote machine
      • Use Forest Admin with a read-only database
      • Configuring CORS headers
      • Running Forest Admin on multiple servers
      • Flatten nested fields (MongoDB)
    • Upgrade
      • Upgrade notes (Rails)
        • Upgrade to v9
        • Upgrade to v8
        • Upgrade to v7
        • Upgrade to v6
        • Upgrade to v5
        • Upgrade to v4
        • Upgrade to v3
      • Upgrade notes (SQL, Mongodb)
        • Upgrade to v9
        • Upgrade to v8
        • Upgrade to v7
        • Upgrade to v6
        • Upgrade to v5
        • Upgrade to v4
        • Upgrade to v3
      • Update your models' definition
      • Monitor your Forest's status
      • Manage your Forest Admin environments programmatically
      • Changing your domain name
      • Migrate to the new role system
      • Push your new version to production
    • Databases
      • Use a demo SQL database
      • Use a demo MongoDB database
      • Populate a postgreSQL database on Heroku
      • Connect to a read replica database
      • Plug multiple schemas
      • Add new databases
      • Manage SQL views
    • Settings
      • Customize your /forest folder
      • Disable automatic Forest Admin schema update
      • Include/exclude models
      • Display extensive logs
      • Laravel specific settings
    • Releases Support
    • Other documentations
Powered by GitBook
On this page

Was this helpful?

  1. Reference Guide

Performance

Loading performance is key to streamlining your operations. Here are a few steps we recommend taking to ensure your Forest is optimized.

PreviousScope on a smart field extracting a json's column attributeNextCharts

Last updated 1 year ago

Was this helpful?

Please be sure of your agent type and version and pick the right documentation accordingly.

This is the documentation of the forest-express-sequelize and forest-express-mongoose Node.js agents that will soon reach end-of-support.

forest-express-sequelize v9 and forest-express-mongoose v9 are replaced by v1.

Please check your agent type and version and read on or switch to the right documentation.

This is still the latest Ruby on Rails documentation of the forest_liana agent, you’re at the right place, please read on.

This is the documentation of the django-forestadmin Django agent that will soon reach end-of-support.

If you’re using a Django agent, notice that django-forestadmin v1 is replaced by v1.

If you’re using a Flask agent, go to the v1 documentation.

Please check your agent type and version and read on or switch to the right documentation.

This is the documentation of the forestadmin/laravel-forestadmin Laravel agent that will soon reach end-of-support.

If you’re using a Laravel agent, notice that forestadmin/laravel-forestadmin v1 is replaced by v3.

If you’re using a Symfony agent, go to the v1 documentation.

Please check your agent type and version and read on or switch to the right documentation.

Performance

Please find here all the hands-on best practices to keep your admin panel performant. Depending on your user's needs, you might either hide or optimize some fields to limit the number of components, avoid a large datasets display or rework complex logic.

You can display bellow performances improvement tricks in . For any further help to improve admin panel performances, get in touch with .

Layout optimization

1. Show only you absolutely need.

As you can see in the below, Smart fields can be quite costly in terms of loading performance. Limiting them to those you need is key.

2. Reduce the number of records per page

3. Reduce the number of fields displayed

You can hide some fields in your table view; this will not prevent you from seeing them in the record details view.

Relationship fields are links to other collection records within your table view:

Having Relationship fields can decrease your performance, especially if your tables have a lot of records. Therefore you should display only those you need and use!

Optimize smart fields performance

Restrict search on specific fields

Sometimes, searching in all fields is not relevant and may even result in big performance issues. You can restrict your search to specific fields only using the searchFields option.

In this example, we configure Forest Admin to only search on the fields name and industry of our collection companies.

/forest/companies.js
const { collection } = require('forest-express-sequelize');
​
collection('companies', {
  searchFields: ['name', 'industry'],
});

In this example, we configure Forest to only search on the fields name and industry of our collection companies.

/forest/companies.js
const { collection } = require('forest-express-mongoose');
​
collection('companies', {
  searchFields: ['name', 'industry'],
});

In this example, we configure Forest to only search on the fields name and industry of our collection Company.

/lib/forest_liana/collections/company.rb
class Forest::Company
  include ForestLiana::Collection

  collection :Company

  search_fields ['name', 'industry']

  action 'Mark as Live'

# ...
end

Disable pagination count

This feature is only available if you're using the forest-express-sequelize (v8.5.3+), forest-express-mongoose (v8.6.5+), forest-rails (v7.5.0+) or django-forestadmin (v1.2.0+) agent.

To paginate tables properly, Forest Admin triggers a separate request to fetch the number of records.

In certain conditions, usually, when your database reaches a point where it has a lot of records, this request can decrease your loading performance. In this case, you can choose to disable it...

  • adding the deactivateCountMiddleware like so:

/routes/books.js
const { PermissionMiddlewareCreator, deactivateCountMiddleware } = require('forest-express-sequelize');

...

// Get a number of Books
router.get('/books/count', deactivateCountMiddleware);
  • adding the deactivateCountMiddleware like so:

/routes/books.js
const { PermissionMiddlewareCreator, deactivateCountMiddleware } = require('forest-express-sequelize');

...

// Get a number of Books
router.get('/books/count', deactivateCountMiddleware);
  • creating a controller in the repository lib/forest_liana/controllers for override the count action

class Forest::BooksController < ForestLiana::ResourcesController
  def count
    deactivate_count_response
  end
end
  • adding a route in app/config/routes.rb before mount ForestLiana::Engine => '/forest'

namespace :forest do
    get '/Book/count' , to: 'books#count'
end

..adding the following middleware in settings.py and set the collection(s) to deactivate.

myproject/settings.py
MIDDLEWARE = [
   'django_forest.middleware.DeactivateCountMiddleware',
   # ...
]

# To deactivate the count on /apps_books/count
FOREST = {
   # ...,
   DEACTIVATED_COUNT = [
      'apps_books', # apps_model
   ],
   # ...
}
app/Http/Controllers/BooksController.php
<?php

namespace App\Http\Controllers;

use ForestAdmin\LaravelForestAdmin\Facades\JsonApi;
use ForestAdmin\LaravelForestAdmin\Http\Controllers\ResourcesController;
use Illuminate\Http\JsonResponse;

class BooksController extends ResourcesController
{
    public function callAction($method, $parameters)
    {
        $parameters['collection'] = 'Book';
        return parent::callAction($method, $parameters);
    }

    public function count(): JsonResponse
    {
        return JsonApi::deactivateCountResponse();
    }
}

adding a route in app/routes/web.php

routes/web.php
<?php

use App\Http\Controllers\BooksController;
use Illuminate\Support\Facades\Route;

Route::get('forest/book/count', [BooksController::class, 'count']);

To disable the count request in the table of a relationship (Related data section):

/routes/books.js
router.get(
  '/books/:recordId/relationships/companies/count',
  deactivateCountMiddleware
);
/routes/books.js
router.get(
  '/books/:recordId/relationships/companies/count',
  deactivateCountMiddleware
);
class Forest::BookCompaniesController < ForestLiana::AssociationsController
  def count
      if (params[:search])
        params[:collection] = 'Book'
        params[:association_name] = 'company'
        super
      else
        deactivate_count_response
    end
  end
end
namespace :forest do
    get '/Book/:id/relationships/companies/count' , to: 'book_companies#count'
end
myproject/settings.py
MIDDLEWARE = [
   'django_forest.middleware.DeactivateCountMiddleware',
   # ...
]

# To deactivate the count on /apps_books/<pk>/company/count
FOREST = {
   # ...,
   DEACTIVATED_COUNT = [
      'apps_books:company', # apps_model:related_field
   ],
   # ...
}

Furthermore, if you want to disable on all relationships at once:

# To deactivate the count on all the related data of the apps_book model
FOREST = {
   # ...,
   DEACTIVATED_COUNT = [
      'apps_books:*', # apps_model:*
   ],
   # ...
}
app/Http/Controllers/BookCompaniesController.php
<?php

namespace App\Http\Controllers;

use ForestAdmin\LaravelForestAdmin\Facades\JsonApi;
use ForestAdmin\LaravelForestAdmin\Http\Controllers\RelationshipsController;
use Illuminate\Http\JsonResponse;

class BookCompaniesController extends RelationshipsController
{
    public function callAction($method, $parameters)
    {
        $parameters['collection'] = 'Book';
        $parameters['association_name'] = 'companies';
        return parent::callAction($method, $parameters);
    }

    public function count(): JsonResponse
    {
        if (request()->has('search')) {
            return JsonApi::deactivateCountResponse();
        } else {
            return parent::count();
        }
    }
}
routes/web.php
<?php

use App\Http\Controllers\BookCompaniesController;
use Illuminate\Support\Facades\Route;

Route::get('forest/book/{id}/relationships/companies/count', [BookCompaniesController::class, 'count']);

You can also disable the count request in a collection only in certain conditions. For instance, you can disable the count if you're using a filter:

/routes/books.js
// Get a number of Books when you have a filtering
router.get('/books/count', (request, response, next) => {
  if (request.query.filters) {
    next(); // count will be done
  } else {
    deactivateCountMiddleware(request, response);
  }
});
/routes/books.js
// Get a number of Books when you have a filter
router.get('/books/count', (request, response, next) => {
  if (request.query.filters) {
    next(); // count will be done
  } else {
    deactivateCountMiddleware(request, response);
  }
});
class Forest::BooksController < ForestLiana::ResourcesController
  def count
    if (params[:filters])
      params[:collection] = 'Book'
      super
    else
      deactivate_count_response
    end
  end
end
myproject/myapp/middlewares.py
class CustomDeactivateCountMiddleware(DeactivateCountMiddleware):

    def is_deactivated(self, request, view_func, *args, **kwargs):
        is_deactivated = super().is_deactivated(request, view_func, *args, **kwargs)
        return is_deactivated and 'search' not in request.GET
myproject/settings.py
MIDDLEWARE = [
   'myproject.myapp.middlewares.CustomDeactivateCountMiddleware',
   # ...
]

# To deactivate the count on /apps_books/count if there is no search argument
FOREST = {
   # ...,
   DEACTIVATED_COUNT = [
      'apps_books', # apps_model
   ],
   # ...
}
app/Http/Controllers/BooksController.php
<?php

namespace App\Http\Controllers;

use ForestAdmin\LaravelForestAdmin\Facades\JsonApi;
use ForestAdmin\LaravelForestAdmin\Http\Controllers\ResourcesController;
use Illuminate\Http\JsonResponse;

class BooksController extends ResourcesController
{
    public function callAction($method, $parameters)
    {
        $parameters['collection'] = 'Book';
        return parent::callAction($method, $parameters);
    }

    public function count(): JsonResponse
    {
        if (request()->has('filters')) {
            return parent::count();
        } else {
            return JsonApi::deactivateCountResponse();
        }
    }
}

One more example: you may want to deactivate the pagination count request for a specific team:

router.get('/books/count', (request, response, next) => {
  // Count is deactivated for the Operations team
  if (request.user.team === 'Operations') {
    deactivateCountMiddleware(request, response);
    // Count is made for all other teams
  } else {
    next();
  }
});
router.get('/books/count', (request, response, next) => {
  // Count is deactivated for the Operations team
  if (request.user.team === 'Operations') {
    deactivateCountMiddleware(request, response);
    // Count is made for all other teams
  } else {
    next();
  }
});
class Forest::BooksController < ForestLiana::ResourcesController
  def count
    if forest_user['team'] == 'Operations'
      deactivate_count_response
    else
      params[:collection] = 'Book'
      super
    end
  end
end
app/Http/Controllers/BooksController.php
<?php

namespace App\Http\Controllers;

use ForestAdmin\LaravelForestAdmin\Facades\JsonApi;
use ForestAdmin\LaravelForestAdmin\Http\Controllers\ResourcesController;
use Illuminate\Http\JsonResponse;
use Illuminate\Support\Facades\Auth;

class BooksController extends ResourcesController
{
    public function callAction($method, $parameters)
    {
        $parameters['collection'] = 'Book';
        return parent::callAction($method, $parameters);
    }

    public function count(): JsonResponse
    {
        if (Auth::guard('forest')->user()->getAttribute('team') === 'Operations') {
            return JsonApi::deactivateCountResponse();
        } else {
            return parent::count();
        }
    }
}

Database Indexing

Indexes are a powerful tool used in the background of a database to speed up querying. It power queries by providing a method to quickly lookup the requested data. As Forest Admin generates SQL queries to fetch your data, creating indexes can improve the query response time.

5. Index the Primary and Unique Key Columns

The syntax for creating an index will vary depending on the database. However, the syntax typically includes a CREATE keyword followed by the INDEX keyword and the name we’d like to use for the index. Next should come the ON keyword followed by the name of the table that has the data we’d like to quickly access. Finally, the last part of the statement should be the name(s) of the columns to be indexed.

CREATE INDEX <index_name>ON <table_name> (column1, column2, ...)

For example, if we would like to index phone numbers from a customers table, we could use the following statement:

CREATE INDEX customers_by_phoneON customers (phone_number)

The users cannot see the indexes, they are just used to speed up searches/queries.

6. Index the Foreign Key Columns

Foreign key columns should be indexed if they are used intensively in Smart fields. In the table below, you can see how drastically it reduces the loading time of the page.

Updating a table with indexes takes more time than updating a table without (because the indexes also need an update). So, only create indexes on columns that will be frequently searched against.

Loading time benchmark

Below is the outcome of a performance test on page load time of the Table view. It highlights the importance of using indexes and limiting the number of columns and lines.

To optimize your smart field performances, please check out .

@forestadmin/agent
forestadmin-agent-django
forestadmin-agent-flask
forestadmin/laravel-forestadmin
forestadmin/symfony-forestadmin
this video
the community
Smart fields
Loading time benchmark
this section