Mantis Bug Tracker - Forums

hello cas, thank you very much for the answer, I tell you is a super old mantis, version 1 that is with a postgres also old, version 9.4, the company in which I am working uses the mantis a lot and is afraid to migrate, these queries are generated by the same mantis and are taking a long time which ...

good afternoon, I am writing to make you a query to see if you had any problems with these selects.
All of them are taking me approximately 7 seconds to run which is generating a slowness in the users of the mantis.
The queries are as follows:

SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt ...

Thanks a lot cas

good night, I make the next consultation to see if you can help me. I have the following query running thousands of times per day, day and night, I estimate that this is caused because users leave their mantis open and the refresh is generating them, what solution would they find so that they do not ...