From user-return-54579-archive-asf-public=cust-asf.ponee.io@ofbiz.apache.org Sat Nov 24 09:06:52 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 63E0218062B for ; Sat, 24 Nov 2018 09:06:52 +0100 (CET) Received: (qmail 65004 invoked by uid 500); 24 Nov 2018 08:06:46 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 64988 invoked by uid 99); 24 Nov 2018 08:06:45 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 24 Nov 2018 08:06:45 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 3BDF5189EE4 for ; Sat, 24 Nov 2018 08:06:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.654 X-Spam-Level: * X-Spam-Status: No, score=1.654 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-1.458, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001, URI_HEX=1.313] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id zsmAQfrFrk_E for ; Sat, 24 Nov 2018 08:06:43 +0000 (UTC) Received: from mail-qt1-f175.google.com (mail-qt1-f175.google.com [209.85.160.175]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 2C6B660FAB for ; Sat, 24 Nov 2018 08:06:43 +0000 (UTC) Received: by mail-qt1-f175.google.com with SMTP id t13so12602997qtn.3 for ; Sat, 24 Nov 2018 00:06:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=ZIHJCzOQu6PnSxcCPTxYPWVJPpFQXz0eWl6Ol2B6pCU=; b=ZEucX2J3sB7hH6y9U93EnFlijlWylQhqieV26T4FLiHgP3ql0KgJ75jsEd+hU5UMMZ ys9Lg1b+pMBpgd+haCZoZwhpfor3gpTN2NHQWfs6u7fkSO9mtxk6DKax27bUp7YxkUY9 7eVgkB62yB/XN+BPzEeqkKjToZ8iwGrhDA/kYWTkffu/2nfPIz67YZ0VCef56KrLBX3Y HyanGpL3Sgv/QYZmwfQZRfJ0bReu5vzQNVrAXfbvY0wfoZ336w5HcQnC3HA/hHP3ySUC nf0jBMMz88MRcC3XeNQzcLUqtknOO58821TxSUq8eoLanNosfVGNHx1kfB9gTLK0FOxU fIDA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=ZIHJCzOQu6PnSxcCPTxYPWVJPpFQXz0eWl6Ol2B6pCU=; b=e2Yc3NrIQUUCIOm1/lPNzeribwaxvtpsvXVKtudkjEHnUMgvk5W5uechm293BJxp+Q LIfU0I7BZGE2FMNwB/+Kwg1kqugNm9hQA/gi11bF7iMana+zmowIdRYsva46iaQOhB2M fXhJy40RCFerekabPrVBp+rnnuVFSQZQXjdwLDwZNUlSLzyWahB2LuBdxTjOE+Dabdqx WgFMroI3yJovvvDDkfRtYqhh9fmAhOYz8SVPYjdOPn2+3oBR2h0tD9co65FlQQ+8Lly4 qAQLj2M6QV+yCaliCB9trS19rOFUz7A+3IHbrHWUSvXyxsLyJdlgMsoPy7YCSD1w7YTt vIaQ== X-Gm-Message-State: AGRZ1gI6HPIK1Ff7ZSnczO7fjRKmrHxB1zOml/UPTOHKEOLJVq9jzt9T XiJZGlq12M/B3YsO1Ran9ZreQFykzLdZTC06+ZKHOQ== X-Google-Smtp-Source: AFSGD/XT4ihZjBe9wvmb6qOTNn98RoBV2XQeKbWgd4T+D9kIMNuroV3YPRrkJr9vr5YhdPXSUXiJneWtFLCShUF/vwo= X-Received: by 2002:aed:2fc4:: with SMTP id m62mr16955378qtd.8.1543046802517; Sat, 24 Nov 2018 00:06:42 -0800 (PST) MIME-Version: 1.0 References: <5358289B.9000100@les7arts.com> <1429011460282-4666589.post@n4.nabble.com> <555D888A.2090709@les7arts.com> <1432211757191-4668827.post@n4.nabble.com> <555DDBC9.8050704@les7arts.com> <1450703776331-4675499.post@n4.nabble.com> <1455570924930-4677172.post@n4.nabble.com> <1499294276072-4707470.post@n4.nabble.com> <1499342617103-4707487.post@n4.nabble.com> <1542981358647-0.post@n4.nabble.com> In-Reply-To: <1542981358647-0.post@n4.nabble.com> From: Rishi Solanki Date: Sat, 24 Nov 2018 13:36:29 +0530 Message-ID: Subject: Re: Using OFBiz with DB2 for i (AS400) database To: ofbizuser Content-Type: multipart/alternative; boundary="00000000000089327b057b6494ce" --00000000000089327b057b6494ce Content-Type: text/plain; charset="UTF-8" Thanks for update Robert, this is great to see evidence that OFBiz scales for large set of data. The performance issue you had, could you please share its details. As far as I know OFBiz can handle millions of products without any issue. Like what you have setup in the cache and how it helps you to resolve your performance problem. Also do you need any external tool to resolve it or OFBiz was capable to do that after setting the cache etc. May be you like to share your experience with community on how easy or difficult it was to overcome from the problem you were having. Best Regards, -- Rishi Solanki Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxsystems.com www.hotwax.co On Fri, Nov 23, 2018 at 7:26 PM robertpic wrote: > Update > > We are running Ofbiz since 16 months (B2B) and now B2C without any troubles > on DB2 (on AS/400 aka iSeries aka Power7/8/9). > > https://shop.odoerfer.com/ > > We had some performance issues because of the big product tree (> 70.000 > products). We used the ofbiz caching to hold the tree one day inside the > cache/memory. > > > > -- > Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html > --00000000000089327b057b6494ce--