[jira] [Commented] (AIRAVATA-3583) slow airavata_django_portal_sdk_userfiles query

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRAVATA-3583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17509857#comment-17509857 ] 

ASF subversion and git services commented on AIRAVATA-3583:
-----------------------------------------------------------

Commit 22e615910d2a0ad5aaa238ce40d52d43e4dc541f in airavata-django-portal's branch refs/heads/staging from Marcus Christie
[ https://gitbox.apache.org/repos/asf?p=airavata-django-portal.git;h=22e6159 ]

AIRAVATA-3583 Update to sdk v1.3.1


> slow airavata_django_portal_sdk_userfiles query
> -----------------------------------------------
>
>                 Key: AIRAVATA-3583
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-3583
>             Project: Airavata
>          Issue Type: Bug
>          Components: Django Portal
>            Reporter: Marcus Christie
>            Assignee: Marcus Christie
>            Priority: Major
>
> Queries for existing data products in the Django Portal are taking longer than 10 seconds for searchsra.
> Example from slow query log:
> {noformat}
> # Time: 220223 15:41:46
> # User@Host: django[django] @ gridfarm004.ucs.indiana.edu [156.56.104.84]
> # Thread_id: 3185092  Schema: django_searchsra  QC_hit: No
> # Query_time: 10.402407  Lock_time: 0.000057  Rows_sent: 0  Rows_examined: 57036
> SET timestamp=1645648906;
> SELECT (1) AS `a` FROM `airavata_django_portal_sdk_userfiles` WHERE (`airavata_django_portal_sdk_userfiles`.`file_path` = '/var/www/portals/gateway-user-data/searching-sra/--REDACTED--' AND `airavata_django_portal_sdk_userfiles`.`file_resource_id` = 'gf4.ucs.indiana.edu_61552681-96f0-462a-a36c-a62a010bffc6' AND `airavata_django_portal_sdk_userfiles`.`username` = '--REDACTED--') LIMIT 1;
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)