id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,branch,changelog,apichanges,internalchanges 8212,Trac ticket processing extremely slow,Chris Toney ,,"Hello, 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?",defect,closed,normal,,ticket system,0.11.2.1,normal,duplicate,restrict_owner,,,,,