Return-Path: X-Original-To: apmail-subversion-dev-archive@minotaur.apache.org Delivered-To: apmail-subversion-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 083D418BFF for ; Thu, 15 Oct 2015 18:44:21 +0000 (UTC) Received: (qmail 48105 invoked by uid 500); 15 Oct 2015 18:44:20 -0000 Delivered-To: apmail-subversion-dev-archive@subversion.apache.org Received: (qmail 48056 invoked by uid 500); 15 Oct 2015 18:44:20 -0000 Mailing-List: contact dev-help@subversion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list dev@subversion.apache.org Received: (qmail 48046 invoked by uid 99); 15 Oct 2015 18:44:20 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Oct 2015 18:44:20 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 0B19EC4990 for ; Thu, 15 Oct 2015 18:44:20 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.099 X-Spam-Level: X-Spam-Status: No, score=-0.099 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=wandisco.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 8zrzvqCOmBfa for ; Thu, 15 Oct 2015 18:44:07 +0000 (UTC) Received: from mail-lb0-f180.google.com (mail-lb0-f180.google.com [209.85.217.180]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 403E02054C for ; Thu, 15 Oct 2015 18:44:07 +0000 (UTC) Received: by lbbwb3 with SMTP id wb3so18916393lbb.1 for ; Thu, 15 Oct 2015 11:44:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wandisco.com; s=gapps; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version:content-type; bh=SqPVVE3Gst8xJpylBDHLvYlniMP/0PnLm7tekoYbLZU=; b=eBer7WIgvTve7DfZXvR8j2fW/p6ETrtYN2tGNWOqWad7wYuUYs+y57JBNuAG1IuBHn dpBL+NpBv/NEzcj1R3v0ITpq1V44mQHib15YL0BZWmdXi9R+QqLSl6VPUnRQPsV4yYs4 3efUytzfzRK/CWa6h0hyJv+5rzk56BDwPrmB4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version:content-type; bh=SqPVVE3Gst8xJpylBDHLvYlniMP/0PnLm7tekoYbLZU=; b=nC6dt7BabYwewx5Su0dI5ul9/vAGzMJ+cnX+I+hmDDl9B/NILgY1h9rkQ51DxIIBrZ u5ih/kNjM35qCf0nhu+1xz4h/LkxYfSNI6oSxmCohW7sRD9K3uu9oIniuO5XdTR4IAi6 dXGedQAWY6HJKTcq3PnwxlsA9x3pSCyqtp0baVypz4xOd8/jw+6uLLFhkdWYrwIjIKlb z6fv0AkUorciAB99pFNB0JNG1hmkSjq99CzhGvVDS9/vIPHSemjMU4vnJmkuDd9IxnjG hUishQUMQNoRXLWQB5n+jJbuME/87Dw9yciW1O7yjgwRlvsaPVOOOw9FELlXWyQsmXc0 FGVg== X-Gm-Message-State: ALoCoQn58cdTsCew1yEeW+MNgZ9ki86ujxy4bKDGknf+AT2bfuumk1ME1CpHc4DNzoK5siVORQFV X-Received: by 10.194.10.162 with SMTP id j2mr12570599wjb.43.1444934646673; Thu, 15 Oct 2015 11:44:06 -0700 (PDT) Received: from localhost (cpc20-farn7-2-0-cust13.6-2.cable.virginm.net. [86.15.228.14]) by smtp.gmail.com with ESMTPSA id l1sm18000536wjx.13.2015.10.15.11.44.05 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 15 Oct 2015 11:44:05 -0700 (PDT) From: Philip Martin To: "Bert Huijben" Cc: 'Branko =?utf-8?Q?=C4=8Cibej'?= , Subject: Re: NFS performance regression in 1.9 References: <87vba82pgl.fsf@wandisco.com> <561FD7F4.3090604@apache.org> <87k2qo2fpy.fsf@wandisco.com> <0f7101d10776$412ba610$c382f230$@qqmail.nl> Date: Thu, 15 Oct 2015 19:44:05 +0100 In-Reply-To: <0f7101d10776$412ba610$c382f230$@qqmail.nl> (Bert Huijben's message of "Thu, 15 Oct 2015 20:21:02 +0200") Message-ID: <87fv1c2cqy.fsf@wandisco.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.4 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain "Bert Huijben" writes: > I'm not able to answer all that, but I do know that your change will > slow Subversion down on Samba shares as used from Windows systems with > that flag. And once one user used it in that way it will stay slow > because the journal mode is stored in the database. > > I don't think just touching a working copy with a client should ever > have such an effect on a working copy. The journal mode is set to TRUNCATE every time we open the database, that doesn't change with my patch. Are you saying that TRUNCATE will be ignored after some previous connection uses DELETE? The documentation doesn't appear to support you: https://sqlite.org/pragma.html#pragma_journal_mode This pragma queries or sets the journal mode for databases associated with the current database connection. Ivan's original change r1659426 stated: The TRUNCATE and DELETE journal modes are compatible, so different Subversion clients with different journal mode should just work with same working copy without problems. -- Philip Martin WANdisco