Return-Path: X-Original-To: apmail-empire-db-user-archive@www.apache.org Delivered-To: apmail-empire-db-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 8D7AE181C4 for ; Fri, 12 Jun 2015 15:31:47 +0000 (UTC) Received: (qmail 56602 invoked by uid 500); 12 Jun 2015 15:31:47 -0000 Delivered-To: apmail-empire-db-user-archive@empire-db.apache.org Received: (qmail 56557 invoked by uid 500); 12 Jun 2015 15:31:47 -0000 Mailing-List: contact user-help@empire-db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@empire-db.apache.org Delivered-To: mailing list user@empire-db.apache.org Received: (qmail 56547 invoked by uid 99); 12 Jun 2015 15:31:47 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Jun 2015 15:31:47 +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 B18DF18221F for ; Fri, 12 Jun 2015 15:31:46 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.879 X-Spam-Level: ** X-Spam-Status: No, score=2.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=verizon.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 8_yyrbCfaDvn for ; Fri, 12 Jun 2015 15:31:40 +0000 (UTC) Received: from omzsmtpe01.verizonbusiness.com (omzsmtpe01.verizonbusiness.com [199.249.25.210]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 7B4AA22F04 for ; Fri, 12 Jun 2015 15:31:39 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=verizon.com; i=@verizon.com; q=dns/txt; s=corp; t=1434123099; x=1465659099; h=from:to:date:subject:message-id:mime-version; bh=nNwMZjYGFJfLUzhRLxbF1QJ2Fb2mfRfRNWJNjMaCsNs=; b=e9Jj/VstHag3nW+U6uHI0ZGD+lgkpquI7171QC4Q/yzQUCHt3Q3FUyk6 HytzHHlf+o68ExHK7rNJ4hcMHM+3aTh9EU0NTA6r/EbHUHY912p7me4QU NmXfUsfH+3tDwnIFTDXvzJlJOKYe0P8RHBWCyD1N4CUeVAiu/LhJlO7pS s=; X-IronPort-Anti-Spam-Filtered: false Received: from unknown (HELO fldsmtpi02.verizon.com) ([166.68.71.144]) by omzsmtpe01.verizonbusiness.com with ESMTP; 12 Jun 2015 15:31:31 +0000 From: "Nguyen, Chieu X" X-IronPort-AV: E=Sophos;i="5.13,602,1427760000"; d="scan'208,217";a="1018299711" Received: from fhdp1lumxc7hb02.verizon.com (HELO FHDP1LUMXC7HB02.us.one.verizon.com) ([166.68.59.189]) by fldsmtpi02.verizon.com with ESMTP; 12 Jun 2015 15:31:31 +0000 Received: from FHDP1LUMXC7V41.us.one.verizon.com ([169.254.1.141]) by FHDP1LUMXC7HB02.us.one.verizon.com ([166.68.59.189]) with mapi; Fri, 12 Jun 2015 11:31:31 -0400 To: "user@empire-db.apache.org" Date: Fri, 12 Jun 2015 11:31:30 -0400 Subject: Peformance Issue Thread-Topic: Peformance Issue Thread-Index: AdClI254gsyvmvT5TzykxwsTdire9g== Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_DB0A1CB7BBFBB9499155678C54C1BF7B01955E8A3AFHDP1LUMXC7V4_" MIME-Version: 1.0 --_000_DB0A1CB7BBFBB9499155678C54C1BF7B01955E8A3AFHDP1LUMXC7V4_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Rainer, I have a SQL that returns 23K records, then, I called the code below to ret= urn the data in a List. It consistently took around 1 - 2 minutes to finis= h the getBeanList call. Is there a way in Empire-DB for me to speed up the performance? List dataList =3D new LinkedList(); DBReader reader =3D new DBReader(); try { org.apache.commons.lang.time.StopWatch sw =3D new org.apache.com= mons.lang.time.StopWatch(); sw.start(); reader.open(dbCmd, dbConn); dataList =3D reader.getBeanList(String.class); sw.stop(); log.info("getDataFromTable: Getting data from table took " + sw.= toString() ); } catch (Exception e) { log.error("getDataFromTable: Error in running SQL " + dbCmd.getS= elect(), e); } finally { reader.close(); } Thank you, Chieu Nguyen --_000_DB0A1CB7BBFBB9499155678C54C1BF7B01955E8A3AFHDP1LUMXC7V4_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Rainer,<= /o:p>

 

 

I have a SQL that returns 23K record= s, then, I called the code below to return the data in a List.  It con= sistently took around 1 – 2 minutes to finish the getBeanList call.&n= bsp;

 

Is there a way in Empire-DB for me to speed up the performance?

 

       List<String>= dataList =3D new LinkedList<String>();

        =

     &n= bsp; DBReader reader =3D new DBReader();

       try

       {

    &nbs= p;      org.apache.commons.lang.time.StopWatch sw = =3D new org.apache.commons.lang.time.StopWatch();

       &nbs= p;   sw.start();        &= nbsp;   <= o:p>

  =            

   &= nbsp;       reader.open(dbCmd, dbConn);

     &nb= sp;     dataList =3D reader.getBeanList(String.= class);=

  &nbs= p;          

    &nbs= p;      sw.stop();

         &nb= sp; log.info("getDataFromTable: Getting data from table took= " + sw.toString() );

&= nbsp;      }

       catch (Exception e) <= /p>

     =   {<= o:p>

  =          log.error("getDa= taFromTable: Error in running SQL " + dbCmd.getSelect(), e);

       = }

    =    finally

       {

         &n= bsp; reader.close();

 = ;      }

 

 

Than= k you,

 

 

Chieu Nguyen<= /p>

= --_000_DB0A1CB7BBFBB9499155678C54C1BF7B01955E8A3AFHDP1LUMXC7V4_--