# Question for Pinecone\_vector

**URL:** <https://community.pinecone.io/t/question-for-pinecone-vector/4548>\
**Category:** Support\
**Tags:** vector-database, embeddings, serverless\
**Created:** [February 14, 2024, 12:40pm UTC](https://community.pinecone.io/t/question-for-pinecone-vector/4548 "2024-02-14T12:40:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dipakbhoi39](https://sea2.discourse-cdn.com/flex020/user_avatar/community.pinecone.io/dipakbhoi39/32/1979_2.png) [@dipakbhoi39](https://community.pinecone.io/u/dipakbhoi39)\
**Post date:** [February 14, 2024, 12:40pm UTC](https://community.pinecone.io/t/question-for-pinecone-vector/4548/1 "2024-02-14T12:40:16Z")

</div>

Dear Support,

We are executing this code inserting 100 rows per time with batch process as per your recommendation in your web site.

Please tell us approximately how much time should we spend to insert these 100 vectors.

We tried storing 1000 vectors in pinecone, it took us 7 seconds and when we tried inserting 100 vectors, it took us 0.37 seconds.

I have tried this code.

 ![image (1)](https://us1.discourse-cdn.com/flex020/uploads/pinecone/original/2X/9/980d4b0cc8ad75b2ee786312eb55451290b54bca.png)

start\_time\_embedding = time.time()  
def chunks(iterable, batch\_size=100):  
“”“A helper function to break an iterable into chunks of size batch\_size.”“”  
it = iter(iterable)  
chunk = tuple(itertools.islice(it, batch\_size))  
while chunk:  
yield chunk  
chunk = tuple(itertools.islice(it, batch\_size))

vector\_dim = 1536  
vector\_count = 100

example\_data\_generator = map(lambda i: (f’id-{i}', [random.random() for \_ in range(vector\_dim)]), range(vector\_count))

async\_results = [  
index.upsert(vectors=ids\_vectors\_chunk, async\_req=True)  
for ids\_vectors\_chunk in chunks(example\_data\_generator, batch\_size=100)  
]

end\_time\_embedding = time.time()  
elapsed\_time\_embedding = end\_time\_embedding - start\_time\_embedding

print(f"Conversational embedding time: {elapsed\_time\_embedding} seconds")

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/pinecone/original/1X/d16664eba369eeee623700cf12feab5562b37eaf.jpeg) [@system](https://community.pinecone.io/u/system)\
**Post date:** [February 28, 2024, 12:40pm UTC](https://community.pinecone.io/t/question-for-pinecone-vector/4548/2 "2024-02-28T12:40:44Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.