Trac ticket processing extremely slow
|Reported by:||Owned by:|
We have trac 0.11.2.1-1 install using sqlite running on a powerful machine (Dual 2.0Ghz processors and 8GB RAM) running CentOS5.2 x64. We are seeing extremely slow response (from 15-30 seconds) for page loads when opening a new ticket and viewing an existing ticket. We have queried the DB directly and responses come back in ms, so no issue with the DB responding slowly. Our entire DB is about 150MB. Further investigation looks like there are a ton of queries being sent to the DB on new ticket creation and when clicking on an existing ticket.
System Information: CentOS5.2 x64 python 2.4.3-21 sqlite 3.3.6-2 mod_python frontend
We are considering moving to postgresql if this will resolve the issue. How easy/painful is that process? Is there any chance of data loss?
Change History (9)
comment:4 by , 10 years ago
|Component:||general → ticket system|
|Keywords:||restrict_owner added; needinfo removed|
|Status:||closed → reopened|