Trac slowness diagnosis

[Martin Langhoff]

On Thu, Mar 29, 2012 at 2:46 PM, Martin Langhoff
<martin.langhoff at gmail.com> wrote:
> On Thu, Mar 29, 2012 at 1:52 PM, Daniel Drake <dsd at laptop.org> 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




m
-- 
 martin.langhoff at gmail.com
 martin at laptop.org -- Software Architect - OLPC
 - ask interesting questions
 - don't get distracted with shiny stuff  - working code first
 - http://wiki.laptop.org/go/User:Martinlanghoff