Re: Durable memory with native persistence isssue

2018-11-01 Thread debashissinha
I figured out it is a different issue with tpcds. Thanks & Regards Debashis Sinha -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Durable memory with native persistence isssue

2018-11-01 Thread Denis Mekhanikov
What version of Ignite do you use? Did you try checking the number of loaded entries using a cache API, but not SQL? For example, you can iterate over all stored entries using a scan query . Denis пт, 26 окт. 2018 г. в 5:02, debashi

Re: Durable memory with native persistence isssue

2018-10-25 Thread debashissinha
I am using tpcds to to benchmark ignite with above configuration . I generate 1gb of data for the table store_sales and then manually create the table and indexes . Then from sql line I use copy from statement to load the data file into the table. As per the tpcds matrix the no of rows processed is

Re: Durable memory with native persistence isssue

2018-10-25 Thread akurbanov
Hello, This seems to be not a performance-related question, the fact that you have mismatch between inserted rows count and count(*) doesn't feel right and seems to be the primary issue to resolve. Could you please give more detail on how you are trying to load your data, what is your node configu

Durable memory with native persistence isssue

2018-10-25 Thread debashissinha
Hi , I want to load 1tb of data in cache and have only 9gb of ram at my disposal. I have three machines in cluster each having 9gb of memory. Please suggest how can i achieve best performance using durable memory and native persistence. I tried once but the number of rows inserted vs the count(*)