From dev-return-39184-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Mon Sep 17 14:26:46 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 1262F180627 for ; Mon, 17 Sep 2018 14:26:45 +0200 (CEST) Received: (qmail 97571 invoked by uid 500); 17 Sep 2018 12:26:45 -0000 Mailing-List: contact dev-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list dev@ignite.apache.org Received: (qmail 97559 invoked by uid 99); 17 Sep 2018 12:26:44 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Sep 2018 12:26:44 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id DC6D2C05DB for ; Mon, 17 Sep 2018 12:26:43 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.182 X-Spam-Level: *** X-Spam-Status: No, score=3.182 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01, URI_HEX=1.313] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id WPVnt8j_9yGS for ; Mon, 17 Sep 2018 12:26:42 +0000 (UTC) Received: from mail-qt0-f181.google.com (mail-qt0-f181.google.com [209.85.216.181]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 318CE5F20D for ; Mon, 17 Sep 2018 12:26:42 +0000 (UTC) Received: by mail-qt0-f181.google.com with SMTP id z8-v6so14994378qto.9 for ; Mon, 17 Sep 2018 05:26:42 -0700 (PDT) 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=pniX72vt0zngX6YT45bUcs+JYmvXZhd+LDKAu5WYmE8=; b=SumXTlpK/FmbxhgvJM7nDouyv0v2Cjb2DUuGV8tQDlrVsLGab8DmwYJ3N0FjElN8/k TvtsS+DvSrsjeCXhstTNCeXR8bHpbQWXxTcwsCiU+X4xtud572OeceLAWem0+FajyzFZ b09Rha3FaLQK5AMQp0bKuk0EefkfJROe5gl4KBhR7D3yAeyOfaFcwNUywLA1L/WEyRKM JdsQuV8r+CSnYqGoZ2yJ6n7lIN/iCPNWcItLswkFW0o6v6rtjA4Uhv/j5SM5tnqllNqO Eiy/xn22RFcXhrg/jn7pA2ovMrbs7aPLQ3C7dbr+cBPdMA8xois1B7/Xhf0v8mmFohDI R54Q== 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=pniX72vt0zngX6YT45bUcs+JYmvXZhd+LDKAu5WYmE8=; b=CLElX9B+nAbbz16CL8RHE9xGRhDAHjQoC6Zob/y5SWGtny6l7VviNqn0rGLi9GdIiB siulerH3e7dpAApwfu0JPywG+EeU9Zi3Kh9qdBLi/m/2RdExBcchLz9Ib/PFroRUcBbp u6Lz0/7oKLq6JGWmcO3IDlfBXU09KUHVi9lQsCUb/FEn6u7TIe3qCMW9A2KGhFCyunR4 hPNlm/GiUUxHUo2h9Y7r3a6mJPLt0u1q6tEdOR2qXi0w/1fCjFvypVsWF4VAopdUdEM3 k6tywrd84xJ8XK7amy8SiCgL4BuySf1Q9bq+MSvA4pUZGn/MEuYWNe3m60fzU2o1dBY2 wNpQ== X-Gm-Message-State: APzg51CeSAEwT+zYYDEQZCvTR2IWPIKxh7N56dz5grVGJ5SePTVks5uC V4dqri7LmNj73/xb+S2QoY57zXcZ7qX13oTDiw55zQ== X-Google-Smtp-Source: ANB0VdZJExoHLxdv64YquJAqsrjbl58yk5r239waWhGomPc/IPRRUbunhc1jlSw/zPXLOLzY9iV+sgmrS3zodyalE5Q= X-Received: by 2002:ac8:23b1:: with SMTP id q46-v6mr16721067qtq.322.1537187201024; Mon, 17 Sep 2018 05:26:41 -0700 (PDT) MIME-Version: 1.0 References: <1537174604673-0.post@n4.nabble.com> <1537177423726-0.post@n4.nabble.com> In-Reply-To: <1537177423726-0.post@n4.nabble.com> From: Ilya Kasnacheev Date: Mon, 17 Sep 2018 15:26:29 +0300 Message-ID: Subject: Re: loadcache very very slow To: dev@ignite.apache.org Content-Type: multipart/alternative; boundary="0000000000001208d5057610490f" --0000000000001208d5057610490f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello! Please avoid writing questions about running Apache Ignite to developers list. Developers list is suited for people who write Apache Ignite's code or plan its features. With regards to your project. I don't have MS SQL Server, and I especially don't have your schema used to create tables. I imagine that you might be missing index on key field in your table (the one that Ignite will use according to your config) and thus it has to resort to full scan while loading tables. Regards, --=20 Ilya Kasnacheev =D0=BF=D0=BD, 17 =D1=81=D0=B5=D0=BD=D1=82. 2018 =D0=B3. =D0=B2 12:43, wt : > hi Alexey > > When i debug it is like going down a maize. what i can see is that it > enters > > class =3D IgniteCacheProxyImpl > > void =3D loadCache > which calls globalLoadCache > which calls globalLoadCacheAsync > > then it goes all into all sorts of classes back and forth and fails becau= se > debugging breaks the connection timeout and the client is disconnected. > > here is the example project Cluster-project(1).zip > < > http://apache-ignite-developers.2346864.n4.nabble.com/file/t604/Cluster-p= roject%281%29.zip> > > > here is sample data data.csv > > > > > > > > -- > Sent from: http://apache-ignite-developers.2346864.n4.nabble.com/ > --0000000000001208d5057610490f--