ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Evgenii Zhuravlev <e.zhuravlev...@gmail.com>
Subject Re: ignite cache as database table
Date Fri, 10 Apr 2020 19:42:34 GMT
Hi.

Can you share both xml configuration and class with entities?

>The difference is the second one will create H2 database table. Then H2
will keep another copy so that it is using double size of memory ?

No, h2 doesn't store a copy of data. Moreover, annotations are used to
prepare QueryEntity configuration, so, it shouldn't have different size.
Have you tried all 3 approaches on a new cluster?

>Another question is, do we have easy way to define cache as a table ?
now we have to use QueryEntity / QueryField , do we have a
@table(name="My_table_name") annotation ?

There is no such annotation. There are 2 ways to configure the table name -
using QueryEntities and by creating table using ddl: "CREATE TABLE ..."

Evgenii



пт, 10 апр. 2020 г. в 11:42, Edward Chen <java148@gmail.com>:

> Hello, trying to load 17m record size of data, size is 3.4G. if pojo
> class field defined with QuerySqlField annotation, Ignite will use
> roughly 9G memory. If we create ignite cache as database table with
> QueryEntity / QueryField, it will use total 20G memory.
>
> The difference is the second one will create H2 database table. Then H2
> will keep another copy so that it is using double size of memory ?
>
> Another question is, do we have easy way to define cache as a table ?
> now we have to use QueryEntity / QueryField , do we have a
> @table(name="My_table_name") annotation ?
>
> Thanks. Ed
>
>
>
>
>

Mime
View raw message