View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0020900 | mantisbt | db mysql | public | 2016-05-11 16:15 | 2016-06-12 00:46 |
Reporter | Universidad-ICESI | Assigned To | atrol | ||
Priority | high | Severity | major | Reproducibility | always |
Status | closed | Resolution | no change required | ||
Product Version | 1.2.19 | ||||
Summary | 0020900: Improvement in the database | ||||
Description | Greetings, We have a problem with the time for database queries because it is a lot, we have arround of 280000 issues and 3000 users in the database, I hope to hear from somebody soon... | ||||
Tags | No tags attached. | ||||
|
|
Thank you very much for the reply. when we open an issue, perform filters by users, in short is a general problem. |
|
Universidad-ICESI, My question was:
you wrote
The provided information is not sufficient to provide help in resolving the issue. A complete and detailed description is required for the support team to get a clear understanding of the problem. Please explain what you do, what are the results you expect to get and what you actually get. Also provide detailed, step-by-step instructions to reproduce the issue; the additional information listed below may also be useful:
|
|
Database operations and optimization is on principle outside the scope of MantisBT support. That being said, if you can demonstrate that the poor performance is caused by our code or database design - or even better, propose solutions to improve things - then we'll see what we can do to address the issues. To identify the root cause, you need to analyze the queries being executed in the slow-loading pages. To do so:
Review the log file, it will display executed queries like this (Screen output has the same information, formatted in a slightly different way): <pre> In the above example, 0.0005 is the execution time (in seconds) - look for the queries that take longest to run. |
|
Thanks @dregad for the note. I thought it would be better to find out in a first step if this is a database issue or not. |
|
Universidad-ICESI, You did not provide any feedback; I am therefore resolving this issue as "no change required". Feel free to reopen the issue at a later time and provide the requested information. |
|