Return-Path: X-Original-To: apmail-jmeter-user-archive@www.apache.org Delivered-To: apmail-jmeter-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D6C4F9BAF for ; Wed, 1 Feb 2012 21:42:39 +0000 (UTC) Received: (qmail 20268 invoked by uid 500); 1 Feb 2012 21:42:39 -0000 Delivered-To: apmail-jmeter-user-archive@jmeter.apache.org Received: (qmail 20164 invoked by uid 500); 1 Feb 2012 21:42:38 -0000 Mailing-List: contact user-help@jmeter.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "JMeter Users List" Delivered-To: mailing list user@jmeter.apache.org Received: (qmail 20155 invoked by uid 500); 1 Feb 2012 21:42:38 -0000 Delivered-To: apmail-jakarta-jmeter-user@jakarta.apache.org Received: (qmail 20151 invoked by uid 99); 1 Feb 2012 21:42:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Feb 2012 21:42:38 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=SPF_SOFTFAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (athena.apache.org: transitioning domain of oliver_lloyd@hotmail.com does not designate 216.139.236.26 as permitted sender) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Feb 2012 21:42:33 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1RshwS-0000BV-KB for jmeter-user@jakarta.apache.org; Wed, 01 Feb 2012 13:42:12 -0800 Date: Wed, 1 Feb 2012 13:42:12 -0800 (PST) From: Oliver Lloyd To: jmeter-user@jakarta.apache.org Message-ID: <1328132532617-5448909.post@n5.nabble.com> In-Reply-To: References: <1328124925803-5448528.post@n5.nabble.com> Subject: Re: REPOST: Adding an option to output results to a db? (not csv or xml.) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >The disadvantage is that writing large numbers of samples to a >database is likely to be slower than writing to a file. Agreed. In principle it is possible to tune inserts to high levels (we got it up to 40k a second) but that was with fairly lightweight data and involved some tweaking of the db params which is non-standard. I guess a better approach might be either to write to a db non synchronously using a flat file as a buffer or maybe using some sort of mem cache. The latter would offer the best throughput but with obvious risks. >What makes you think that Listeners depend on the output format? I was thinking in terms of loading results offline. Ideally if results are written to a db then it should be possible to point a listener at this source. We'll review the common code on that. Thanks for your replies; we'll try and spend some more time on this. ----- http://www.http503.com/ -- View this message in context: http://jmeter.512774.n5.nabble.com/REPOST-Adding-an-option-to-output-results-to-a-db-not-csv-or-xml-tp5448528p5448909.html Sent from the JMeter - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org For additional commands, e-mail: user-help@jmeter.apache.org