[Paging] QueryCursor and SqlQuery

2017-07-26 Thread woo charles
Hi, How can I do paging when query from ignite cache? Can I get records by range? specific page? If I have 1 rows of records with page size set to 20, how can I get the 21-40 (Page 2)?

[TCP Discovery] connection ip configuration

2017-06-26 Thread woo charles
Hi, I would like to know how to specify the connection ip if the server has more than one ips during the TCP Discovery. Server A has 2 lan cards and so 2 ips (e.g. 1.2.3.4 and 7.8.9.0). I have applied the following configuration for the TCP discovery and the server is well connected. However, whe

Affinity Collocation and missing data

2017-06-06 Thread woo charles
hi, I have tried to implement the cache with Affinity Collocation Object personKey1 = new AffinityKey("myPersonId1", "myCompanyId");Object personKey2 = new AffinityKey("myPersonId2", "myCompanyId"); Person p1 = new Person(personKey1, ...);Person p2 = new Person(personKey2, ...); // Both, the com

Re: Input data is no significant change in multi-threading

2017-04-25 Thread woo charles
> Or I missed smth? > > Anyway, if you do not get a speed up but you sure you should, then a > bottleneck have to be found at first. > > On Fri, Apr 21, 2017 at 5:02 AM, woo charles > wrote: > >> If the data is buffered in client side, the bottleneck should be als

Re: Input data is no significant change in multi-threading

2017-04-20 Thread woo charles
If the data is buffered in client side, the bottleneck should be also in client side. If I use 2 programs to input same set data, it should be a significant change in data input time. Is it right? 2017-04-21 6:46 GMT+08:00 Dmitriy Setrakyan : > > On Wed, Apr 19, 2017 at 10:16 PM, woo c

Re: Input data is no significant change in multi-threading

2017-04-19 Thread woo charles
treamer (call addData) slowly > and it is possible to utilize more resources for it. Of course remote nodes > should be able to bear pressure of data. > Performance can increased, but usually slightly as network will be a > bottleneck. > > > On Wed, Apr 19, 2017 at 12:29 PM, woo ch

Re: Input data is no significant change in multi-threading

2017-04-19 Thread woo charles
ads. > > > > On Wed, Apr 19, 2017 at 4:30 AM, woo charles > wrote: > >> When I try to input data(80 table, each 1 records) to a cluster with >> 3 server node(each 2 gb), it only has a small change in time if multi >> thread is performed >> (ie. max decrease

Input data is no significant change in multi-threading

2017-04-18 Thread woo charles
When I try to input data(80 table, each 1 records) to a cluster with 3 server node(each 2 gb), it only has a small change in time if multi thread is performed (ie. max decrease from 8s to 6.5s if using IgniteCache) Is it normal? Also, I found that multi thread do not affect the data input spe

Re: Slow on 1st time query "SQL Join"

2017-04-18 Thread woo charles
time reduced to 50-60ms in >>> client mode. >>> >>> I've used a trick to avoid declaring all the caches in configuration >>> file or calling getOrCreateCache for each of them. >>> To give it a try, just add the line below before the queries execution >&g

Re: Help with Web agent

2017-04-13 Thread woo charles
Did you update the token in default.properties? The Security token in your new setup web console should be different from GridGain web console one. 2017-04-13 16:13 GMT+08:00 ArcherUnicorn <969959...@qq.com>: > My "URI to Ignite node REST server:" is "https://console.gridgain.com"; , > and > I ca

Re: Help with Web agent

2017-04-13 Thread woo charles
For my testing web console, its console server is pointed to 9000 port not 3000 port. 2017-04-13 13:42 GMT+08:00 Harish Patibandla : > Hi Everyone, >I am unable to run web agent on the server , web console is up and > running but was unable to get the agent running .I am getting below error >

Re: Slow on 1st time query "SQL Join"

2017-04-13 Thread woo charles
therefore allowing to skip these on the > next query runs. > To disable client mode in your example just pass false to > Ignition.setClientMode(true) > > Kind regards, > Alex > > > > 13 апр. 2017 г. 5:22 AM пользователь "woo charles [via Apache Ignite > User

Re: Slow on 1st time query "SQL Join"

2017-04-12 Thread woo charles
You are running the query from a client node what implies additional >> network round trips. >> Try to run queries from a server node. In my environment it reduced the >> time from about 7 seconds to 220ms for the first run. >> >> Kind regards, >> Alex. >> &

Re: Slow on 1st time query "SQL Join"

2017-04-10 Thread woo charles
r it what takes some additional time compared to the >> following runs. >> >> Kind regards, >> Alex >> >> 10 апр. 2017 г. 8:13 AM пользователь "woo charles [via Apache Ignite >> Users]" <[hidden email] >> <http:///user/SendEmail.j

Slow on 1st time query "SQL Join"

2017-04-09 Thread woo charles
Hi, I set up 3 Server nodes(8 cpu, 1gb ram) in the same server. 2 table each 1 rows are entered. When I perform a *SQL Join* query on two table and run it 100 times, I found that the first query is much slower than other(i.e. First query used 13s & other used around 0.02s). Why will it happe

Re: Server Client Connection

2017-04-07 Thread woo charles
Can I move some connections to other nodes in order to reduce the workload on the oldest server node? 2017-04-03 22:26 GMT+08:00 Nikolai Tikhonov : > Yes, it's absolutely ok. Do not worry:) > > On Mon, Apr 3, 2017 at 5:01 AM, woo charles > wrote: > >> Hi, >> >

CPU Usage on distributed queries

2017-04-02 Thread woo charles
Hi, I have conducted a test on distributed query performance. I have created 5 server nodes(java) in 3 different server. 4 records are entered. I created 80 Threads and each thread looped following sql 100 times. select * from user where age<18 (about 50 records is selected) *** age is not

Re: Server Client Connection

2017-04-02 Thread woo charles
s/network-config > 3. https://apacheignite.readme.io/docs/leader-election > > > On Wed, Mar 29, 2017 at 4:16 AM, woo charles > wrote: > >> Hi >> >> I have created 5 server nodes in 5 jvm process in 3 jvms. >> >> After the client node has started up, t

Server Client Connection

2017-03-28 Thread woo charles
Hi I have created 5 server nodes in 5 jvm process in 3 jvms. After the client node has started up, the oldest server node will establish a connection to the client node through client's communication port (471XX) periodically. May I know the reasons for this? if it is because of Leader Election,