Trac slowness diagnosis

Martin Langhoff martin.langhoff at
Thu Mar 29 15:22:40 EDT 2012

On Thu, Mar 29, 2012 at 2:46 PM, Martin Langhoff
<martin.langhoff at> wrote:
> On Thu, Mar 29, 2012 at 1:52 PM, Daniel Drake <dsd at> wrote:
>> Through some profiling I found that an inefficient trac design causes
>> about 17,000 identical SQL queries to be executed during each page
>> load, related to the number of users in the system (we have about
>> 5.5k).

BTW, when you are dealing with this kind of SQL abuse, every little
thing that lowers your latency helps alleviate the pain:

 - have the DB on the same host
 - ensure the python or php runtime connects to the DB via a unix socket
 - shooting the programmer^W^W^Wseparating to a different DB instance

 martin.langhoff at
 martin at -- Software Architect - OLPC
 - ask interesting questions
 - don't get distracted with shiny stuff  - working code first

More information about the Devel mailing list