On Thu, Mar 29, 2012 at 2:46 PM, Martin Langhoff <[email protected]> wrote: > On Thu, Mar 29, 2012 at 1:52 PM, Daniel Drake <[email protected]> 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 -- [email protected] [email protected] -- Software Architect - OLPC - ask interesting questions - don't get distracted with shiny stuff - working code first - http://wiki.laptop.org/go/User:Martinlanghoff _______________________________________________ Devel mailing list [email protected] http://lists.laptop.org/listinfo/devel
