From owner-freebsd-ports@FreeBSD.ORG Thu Jul 3 02:52:58 2014 Return-Path: Delivered-To: ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id D8238CAC; Thu, 3 Jul 2014 02:52:58 +0000 (UTC) Received: from hades.sorbs.net (hades.sorbs.net [67.231.146.201]) by mx1.freebsd.org (Postfix) with ESMTP id C495A2064; Thu, 3 Jul 2014 02:52:58 +0000 (UTC) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII Received: from isux.com (firewall.isux.com [213.165.190.213]) by hades.sorbs.net (Oracle Communications Messaging Server 7.0.5.29.0 64bit (built Jul 9 2013)) with ESMTPSA id <0N8400E2B85U7600@hades.sorbs.net>; Wed, 02 Jul 2014 19:56:21 -0700 (PDT) Message-id: <53B4C581.5060508@sorbs.net> Date: Thu, 03 Jul 2014 04:52:49 +0200 From: Michelle Sullivan User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.24) Gecko/20100301 SeaMonkey/1.1.19 To: Matthew Seaman , demon@FreeBSD.org, ports@freebsd.org Subject: Patch (not perfect but half way there) for DBIx::SearchBuilder... X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 03 Jul 2014 02:52:58 -0000 Matthew, "Demon" (cc'd you two specifically because the patch affects ports you maintain directly) I created a patch a while ago and sent it off to Jesse and the RT-Users mailing list to fix extremely slow loading of tickets for Request-Tracker. The patch is for DBIx::Searchbuilder->Fields() and you can see it here: https://rt.cpan.org/Public/Ticket/Attachment/WithHeaders/733854 (bug: https://rt.cpan.org/Public/Bug/Display.html?id=96902 ) If it were to be shipped as an 'option' in FreeBSD ports would it be attached to DBIx::SearchBuilder or RT 4.x? (the patch is against DBIx::SearchBuilder, but very specifically affects RT) For a brief background on it... I've been trying to upgrade SORBS Support from RT3.8 to RT4.0 and ticket loads are 4-6 minutes in RT4.0 compared to my old 3.8 system.. The cause being that the new System has a Pg cluster of 4 servers which are in their own datacentres.. the RT 'Front Ends' being in public network space in other datacentres. This is a fairly standard security model.. put your application servers in a DMZ (or public network) and keep the Database Servers locked in their own network.. Just a modest 20ms Ping time and 3 schemas (RT (public), Bucardo and Postgres) causes the ticket load to be 4-6 minutes per ticket - single user, 2 frontends. Patching DBIx::SearchBuilder with the patch in the bug, drops that down to 7 seconds. Best Practical have been less than helpful, so thinking about writing a patch for FreeBSD ports as a new 'option' as most of my servers are FreeBSD with my own Pkg Repo... Thoughts? (Read the bug for the 'half way there' bit - the whole ->Fields() call has a bad flaw.. and FWIW, a user running MySQL will not be affected by my patch in any negative way as MySQL is case insensitive for table names - unlike PostgreSQL and others.) Best regards, -- Michelle Sullivan http://www.mhix.org/