ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lucky <wanxing...@163.com>
Subject insert data took too much time
Date Tue, 10 Oct 2017 11:39:53 GMT
   I excute the sql like this:
        insert into "mycache".cacheInfo (_key,fid) values('111','111'),('222','222') ...
   This will insert 90000 records at one time and it took 100 seconds. 
   I create index on column fid.
   The ignite version is 2.2 and the table has no record.
   the configuration is set writeBehind to true ,and writeSynchronizationMode is set to PRIMARY_SYNC

   what did I miss ?
   Thank you.
View raw message