# Create index spent too much time

**URL:** <https://community.neo4j.com/t/create-index-spent-too-much-time/58420>\
**Category:** Conferences, Meetups, & Events\
**Tags:** migrated\
**Created:** [January 18, 2023, 12:55am UTC](https://community.neo4j.com/t/create-index-spent-too-much-time/58420 "2023-01-18T00:55:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Peter\_Lian](https://avatars.discourse-cdn.com/v4/letter/p/f4b2a3/32.png) [@Peter\_Lian](https://community.neo4j.com/u/Peter_Lian)\
**Post date:** [January 18, 2023, 12:55am UTC](https://community.neo4j.com/t/create-index-spent-too-much-time/58420/1 "2023-01-18T00:55:09Z")

</div>

I were trying to create index for node's property :

```auto
create index process_pid if not exists for (n:Process) on n.pid

```

It take about **10 minutes in 100 million nodes**. However, in the case of **640 million nodes, it take 10 hours** , what made so difference? All setting (neo4j.conf...) stay the same in both 100 and 640 million nodes but only the number of node that needed to create index are different.

I had tried what [here](https://github.com/neo4j/neo4j/issues/12255) suggested, i.e., adding the following into neo4j.conf.

```auto
dbms.jvm.additional=-Dorg.neo4j.kernel.impl.index.schema.GenericNativeIndexPopulator.blockBasedPopulation=true

```

but nothing change.

I tried to change the neo4j.conf setting. In 100 million case, all my heap.initial.size, heap.max.size and pagecache.size are all default value, in 640 million case I setting as 31G,31G and 467G, respectively (command line suggestion), but also, nothing change (still very long time to create index).

Remark : CPU 44 Core 88 threads and Memory 512 GB in my computer. Neo4j version : enterprise 5.3. I use command line open neo4j via neo4j console in bin folder (neo4j server).

1. Why make this and how to fix it? Thanks.