Marcus Christie created AIRAVATA-3583:
-----------------------------------------
Summary: 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
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)
