View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006180 | Composr website (compo.sr) | [Composr testing - manual ideas] [All Projects] General | public | 2025-03-27 09:50 | 2025-03-27 09:50 |
| Reporter | Bitmain | Assigned To | |||
| Severity | Major-bug | ||||
| Status | non-assigned | Resolution | open | ||
| Summary | 0006180: A problem with SELECT m_moniker,m_resource_page,m_resource_type,m_resource_id FROM ccms_url_id_monikers | ||||
| Description | I got the email from my domain host provider, sent me a sql code for my db cres01_ccms1.sql. They told me that script or sql query for `ccms_url_id_monikers`should be optimized and that their query/results take too long time, 310 second or more. | ||||
| Steps To Reproduce | They did, and told me it take too much time to give a result, 310 seconds or more. | ||||
| Additional Information | I did not find a place here, to upload the SQL file they send to me. Is there any place to upload the file? I did run same query on DB server, and got the results in less then 10 seconds. Or SQL file is here: https://www.dropbox.com/scl/fi/fvupjuq8cgra0jqwxec09/cres01_ccms1.sql.zip?rlkey=h2pexfqd6m5ib09v4x0b4ibi5&st=qlbvlfx0&dl=0 | ||||
| Tags | No tags attached. | ||||
| Time estimation (hours) | |||||
| Sponsorship open | |||||
