Re: loadcache very very slow

2018-09-17 Thread wt
hi The reason i am asking here and not on the users forum is to get down to the code details of how loadcache works and specifically what the developers recommendation is on using it for bulk load operations. In reading up on the subject, i discovered that it is suggested to override the method an

Re: loadcache very very slow

2018-09-17 Thread Alexey Kuznetsov
Indeed. You should ask such questions on user list. Just start a thread there + attach a DDL script of your schema in SQL Server. -- Alexey Kuznetsov

Re: loadcache very very slow

2018-09-17 Thread Ilya Kasnacheev
Hello! Please avoid writing questions about running Apache Ignite to developers list. Developers list is suited for people who write Apache Ignite's code or plan its features. With regards to your project. I don't have MS SQL Server, and I especially don't have your schema used to create tables.

Re: loadcache very very slow

2018-09-17 Thread wt
hi Alexey When i debug it is like going down a maize. what i can see is that it enters class = IgniteCacheProxyImpl void = loadCache which calls globalLoadCache which calls globalLoadCacheAsync then it goes all into all sorts of classes back and forth and fails because debugging breaks

Re: loadcache very very slow

2018-09-17 Thread Alexey Kuznetsov
Hi, As I see from code of CacheAbstractJdbcStore it will try to use range query if possible. see: CacheAbstractJdbcStore#loadCacheRange As you are using SQL Server make sure that SQLServerDialect was set to your store, please provide config generated by Web Console. Or just set a break point a

loadcache very very slow

2018-09-17 Thread wt
Hi I have a project that is generated by the web console (2.5) and it is loading an integrated db (SQL Server) table that has 4.5 million rows. When running the load cache it is loading 1-3 records per second which is unacceptable. Looking at the documentation i see examples of the overridden load