[Paging] QueryCursor and SqlQuery

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

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,

Affinity Collocation and missing data

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

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

ed to 1 if data set is > put twice? > 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 <ignite.charl...@gmail.com> > wrote: > >&

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

, 2017 at 10:16 PM, woo charles <ignite.charl...@gmail.com> > wrote: > >> When I call addData() in streamer. this data will send & buffer in server >> node. is that correct? >> If I correct, this data will buffer in random server node or only the one >>

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

ataStreamer send jobs to remote nodes, to utilize multiple >>> threads on remote nodes. >>> >>> In multi-node grid IgniteDataStreamer usually shows better results than >>> single updates in from multiple threads. >>> >>> >>> >>>

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

updates in from multiple threads. > > > > On Wed, Apr 19, 2017 at 4:30 AM, woo charles <ignite.charl...@gmail.com> > 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

Input data is no significant change in multi-threading

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

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

> logic in your example. >>> IgniteStorage.getInstance().getIgniteCache(Quote.class.getName(), 0 >>> ).unwrap(IgniteCacheProxy.class).context().kernalContext(). >>> cache().createMissingCaches(); >>> >>> Kind regards, >>> Alex. >>> &g

Re: Help with Web agent

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

Re: Help with Web agent

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

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

ic > cache creation requests being sent 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

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

fedot...@gmail.com>: > >> Hi 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

Slow on 1st time query "SQL Join"

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

CPU Usage on distributed queries

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

Re: Server Client Connection

nite.readme.io/docs/network-config > 3. https://apacheignite.readme.io/docs/leader-election > > > On Wed, Mar 29, 2017 at 4:16 AM, woo charles <ignite.charl...@gmail.com> > wrote: > >> Hi >> >> I have created 5 server nodes in 5 jvm process in 3 jvms. >> >&

Server Client Connection

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