# Slow to initial secondary indexes in cold restart

**URL:** <https://discuss.aerospike.com/t/slow-to-initial-secondary-indexes-in-cold-restart/4119>\
**Category:** General Discussion\
**Tags:** secondary\
**Created:** [May 3, 2017, 9:34am UTC](https://discuss.aerospike.com/t/slow-to-initial-secondary-indexes-in-cold-restart/4119 "2017-05-03T09:34:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![RockyTu](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rockytu/32/785_2.png) [@RockyTu](https://discuss.aerospike.com/u/RockyTu)\
**Post date:** [May 3, 2017, 9:34am UTC](https://discuss.aerospike.com/t/slow-to-initial-secondary-indexes-in-cold-restart/4119/1 "2017-05-03T09:34:52Z")

</div>

I use Aerospike 3.9.0 community version.

I have 154 secondary indexes. And the records number in test namespaces is not so many. please check following info, is it normal behavior to take more than 1 hour to load all the secondary index?

`May 03 2017 07:36:26 GMT: INFO (sindex): (secondary_index.c:4872) Sindex-ticker: ns=test si=<all> obj-scanned=500000 si-mem-used=3185903 progress = 4% est-time=4315578 ms`

Aerospike config is as following

```auto
    namespace test {
            replication-factor 2
            memory-size 4G
            default-ttl 0 # 30 days, use 0 to never expire/evict.
            storage-engine device {
                    file /opt/aerospike/data/test.dat
                    filesize 16G
                    data-in-memory false # Store data in memory in addition to file.
            }
    }

```

---

<div class="post-metadata">

**Author:** ![Albot](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/albot/32/2076_2.png) [@Albot](https://discuss.aerospike.com/u/Albot)\
**Post date:** [May 4, 2017, 11:41pm UTC](https://discuss.aerospike.com/t/slow-to-initial-secondary-indexes-in-cold-restart/4119/2 "2017-05-04T23:41:08Z")

</div>

It takes about 3 hours to rebuild my 70 indexes. They’re not cheap, or fast, when it comes to recreating them. Probably limited by your storage if its that low of a dataset.

---

<div class="post-metadata">

**Author:** ![RockyTu](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rockytu/32/785_2.png) [@RockyTu](https://discuss.aerospike.com/u/RockyTu)\
**Post date:** [May 15, 2017, 7:04am UTC](https://discuss.aerospike.com/t/slow-to-initial-secondary-indexes-in-cold-restart/4119/3 "2017-05-15T07:04:28Z")

</div>

okie, so it is an expected behavior. Thanks