Re:Re: Re:Re: Re:Issue about ignite-sql limit of table quantity

2018-04-01 Thread fvyaba
Thanks D. At 2018-04-01 23:07:25, "Dmitriy Setrakyan" wrote: Hi Fvyaba, In order to avoid memory overhead per table, you should create all tables as part of the same cache group: https://apacheignite.readme.io/docs/cache-groups D. On Mon, Mar 26, 2018 at 7:26

Re: Re:Re: Re:Issue about ignite-sql limit of table quantity

2018-04-01 Thread Dmitriy Setrakyan
Hi Fvyaba, In order to avoid memory overhead per table, you should create all tables as part of the same cache group: https://apacheignite.readme.io/docs/cache-groups D. On Mon, Mar 26, 2018 at 7:26 AM, aealexsandrov wrote: > Hi Fvyaba, > > I investigated your

Re: Re:Re: Re:Issue about ignite-sql limit of table quantity

2018-03-26 Thread aealexsandrov
Hi Fvyaba, I investigated your example. In your code you are going to create new cache every time when you are going to create new table. Every new cache will have some memory overhead. Next code can help you to get the average allocated memory: try (IgniteCache cache =

Re: Re:Re: Re:Issue about ignite-sql limit of table quantity

2018-03-26 Thread aealexsandrov
Hi Fvyaba, I investigated your example. In your code you are going to create new cache every time when you are going to create new table. Every new cache will have some memory overhead. Next code can help you to get the average allocated memory: try (IgniteCache cache =

Re:Re: Re:Issue about ignite-sql limit of table quantity

2018-03-23 Thread fvyaba
Hi Andrei: Thanks for your answer! My laptop run on MacOS(16G RAM),I just ran a simple test, it seems 'table creation' cost much much more memory than 'data creation',and we got 'IgniteOutOfMemoryException: Out of memory in data region [name=default, initSize=256.0 MiB, maxSize=3.2 GiB,