Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The summary page of some studies loads very long #152

Closed
therter opened this issue Mar 16, 2020 · 4 comments
Closed

The summary page of some studies loads very long #152

therter opened this issue Mar 16, 2020 · 4 comments

Comments

@therter
Copy link

therter commented Mar 16, 2020

Every screenshot will be loaded in its original resolution, when the summary page is loaded. This can take very much time. For example for this page.

@p-a-s-c-a-l p-a-s-c-a-l added this to Backlog: Low Priority in T1.3 Climate Services Co-creation via automation Mar 24, 2020
@p-a-s-c-a-l p-a-s-c-a-l added this to the D1.4 CLARITY CSIS v2 milestone Mar 24, 2020
@p-a-s-c-a-l
Copy link
Member

1st we should remove all report images from test study 1. I assume this is a manual process?
2nd we should change image format of screenshots from PNG to JPEG.

@therter
Copy link
Author

therter commented Mar 25, 2020

1st we should remove all report images from test study 1. I assume this is a manual process?
2nd we should change image format of screenshots from PNG to JPEG.

I will do this

@therter
Copy link
Author

therter commented Mar 26, 2020

1st we should remove all report images from test study 1. I assume this is a manual process?

All report images from study 1 are removed. But I haven't removed the unused image files from the csis directory, yet.

2nd we should change image format of screenshots from PNG to JPEG.

JPEG images are now used

@therter
Copy link
Author

therter commented Mar 31, 2020

Unused files will be deleted from the file system, if the status of the file is temporary (table file_managed, field status = 0) and the last change was 3 month ago (this can be changed here).
But the current drupal version does not change the status of orphaned files to temporary. (See here)

The status can be set manually via the database. For example with an update statement like this

update file_managed set status = 0 where fid in ( select m.fid from file_managed m left join file_usage u on (m.fid = u.fid) where coalesce(u.count, 0) = 0 )

To delete the files now instead of after three months, the database fields "created" and "changed" should be changed.

All files, which are temporary and the last change was 3 month ago, will be deleted during the drupal cron job (The drupal cron job can be configured here). Note: one run of the drupal cron job removes a maximum of 100 files.

@therter therter closed this as completed Mar 31, 2020
T1.3 Climate Services Co-creation automation moved this from Backlog: Low Priority to Done Mar 31, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
No open projects
Development

No branches or pull requests

2 participants