Geoff wrote:
>>The biggest bottleneck for me has always been SQL (queries on large tables without adequate indexes, or unnecessary repetition of queries when a single query would suffice, etc).<< I did some basic timing over the weekend to see why things were running more slowly than I expected. The speed problems were coming from two places: WebKit.cgi and pyPgSQL. Switching to mod_webkit made an enormous quantitative and qualitative speed improvement. Switching from pyPgSQL to psycopg made a smaller difference, but did still cut SQL query time down to about half of what I'd been seeing. ...Edmund. ------------------------------------------------------- Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss
