Netbox 3.3.5 database performance issue

[aakozlov85]

Hello guys!
We 've got netbox instance v3.3.5 at VM and there are some performance issues. The database contains about 1257 devices and it take for a long time to display netbox info when i press "Devices" button (about 4 second). The database and redis server - all at the same VM.
Please have a look for browser get request time response.

All other buttons (Device Type, Manufactors and etc.) works fine and it takes about 0,5 seconds to go.The problem is only with devices, as they have a lot of elements.

Please advice how to diagnose and fix it?

[kkthxbye-code]

What is your pagination setting? Please also list what columns you have selected. A likely reason is that you have a custom link column selected.

[kkthxbye-code]

Please click the configure table button and post a screenshot of all columns in the Selected Columns box.

[kkthxbye-code]

Please do note that having 1000 as the pagination size is bound to be slow for tables with a lot of rows. It's fast for other pages probably because you don't have close to 1000 objects of that type. 4 seconds seems about right for 1000 pagination size for devices, you might get it down a little by deselecting the columns you don't use, but really you should just lower the pagination size to something more reasonable, like 50 or 100.

[aakozlov85]

[aakozlov85]

but really you should just lower the pagination size to something more reasonable, like 50 or 100.

ok. how to accomplish this for all users? are there any settings for this?

[kkthxbye-code]

The default is 50 or 100 I believe, you have changed it yourself for your user to 1000 most likely.

There's a couple of options:

https://docs.netbox.dev/en/stable/configuration/miscellaneous/#max_page_size

Sets the maximum page size, this also applies to the API though.

https://docs.netbox.dev/en/stable/configuration/default-values/#default_user_preferences

Allows you to set the default pagination size, but as I said the default is already lower than 1000.

[aakozlov85]

yes you are right.
we 've MAX_PAGE_SIZE = 1000.
i decreased this value to 25 and now devices page download speed about 2.5 seconds.

What about cache settings? Can i set cache_timeout to improve performance one more?

[kkthxbye-code]

Queryset caching was removed in v3.0 so CACHE_TIMEOUT doesn't do anything anymore.

[aakozlov85]

ok. thanks a lot.
Are there any way to set selected columns for all users in table configuration?