Odoo 12 Changing Upload limits
Odoo12 has been very stable, even with many community modules. This posting is about different options for file size limits, upload limits, and data size considerations. These are mostly just notes to myself in case I need to come back to these for future installs.
Nginx Front end upload limits:
https://www.soladrive.com/support/knowledgebase/4835/How-to-Increase-or-Limit-the-Database-Upload-Size-Allowed-for-Odoo-Front-End.html
...
server {
client_max_body_size 300M;
...
location / {
...
proxy_send_timeout 300;
}
}
Open Odoo Database Manager
Now you can launch the Odoo database manager and upload the backup file (change odoo-url to an actual URL of your Odoo instance):
https://odoo-url/web/database/manager
Odoo data size limits and design issues
https://www.odoo-consultants.com/odoo-data-size-limits/
- Assess data volume from the beginning. Large clients already have quite a precise idea of how many transactions they run on a daily / weekly / monthly basis.
- Each client is specific. Tables do not grow evenly inside all Odoo systems. They follow data flow logic and this is the one you ought to follow.
- Modules, database structure, scaling, clustering, partitioning and indexing must be used according to data growth logic.
- DO NOT use standard community modules just because you think they are going to make you gain time. Most of the modules I see can do the trick on small to medium-size implementations… but their API versioning and coding will be bottlenecks which will end-up ruining the implementation and make the system unusable in the long run.
- Store data “store through”. DO NOT use functions. These will kill you with large data.
Change odoo forms to allow larger sizes
https://www.odoo.com/fr_FR/forum/aide-1/file-size-limit-error-42610
https://www.odoo.com/fr_FR/forum/aide-1/error-in-attachment-from-documents-page-43823
addons/web/static/src/js/fields/basic_fields.js: this.max_upload_size = 99 * 1024 * 1024; // 99 MB
addons/muk_web_utils/controllers/backend.py: 'max_upload_size': int(params.get_param('muk_web_utils.binary_max_size', default=25))
addons/muk_web_utils/static/src/js/fields/image.js: this.max_upload_size = result.max_upload_size * 1024 * 1024;
addons/muk_web_utils/static/src/js/fields/binary.js: this.max_upload_size = result.max_upload_size * 1024 * 1024;
ddons/muk_web_utils/models/res_config_settings.py: res.update(binary_max_size=int(params.get_param('muk_web_utils.binary_max_size', 25)))