attachment large object and ir attachment force storage version 10 very slow when reverting to filestore

[gmathers]

I am trying to revert the Odoo files from the PG large objects to the filestore. When i switch the location to "file", it looks as though the files will take weeks to convert for PG to filestore. Is there any way to speed this up? Our database is about 3 GB with the large objects included. Thanks!

[yelizariev]

Hello!

3 GB doesn't look as a big deal.
Do you make the migration on production or on a separate deployment?
You may try to add self.env.cr.commit() here, so the transaction data will not grow too much

misc-addons/ir_attachment_force_storage/models.py

Lines 76 to 79 in b30dfdf

	for attach in self.search(domain):
	# we add url because in some environment mimetype is not computed correctly
	# see https://github.com/odoo/odoo/issues/11978
	attach.write({"datas": attach.datas, "url": attach.url})

[gmathers]

I have tried running the LO to file migration both on a staging deployment and on our production system - with similiar slow results. I have also tried running it with workers = 0 and with workers > 0 with no difference.
I tried adding the commit statement after line 79 "attach.write..." and the progress appears to be even slower.
Do you have any other suggestions? Thanks!

[yelizariev]

How many attachments you have? Maybe you should commit every 100 (or 1000) records?
I don't have other ideas. You may need to measure performance somehow for further analysis.