1M+ CSV row data to DB

I have a csv that I intend to add to a collection in my database but that csv has millions of rows.

The process of adding each column and its rows under an attribute using the api would get me rate limited as it adds one by one. What path do i take?

Use the server sdk and an API key, this way you won't be rate limited

hmm didn't know that... So the only thing I would have to deal with is the time it takes to add

Add them in batches of like 50 or so instead of awaiting all of them individually

appwrite doesn't support batches... I think this is a requested feat or do you mean multi threads

No, appwrite does not support bulk updates. It does next release tho. What I meant was to not waiti for the result of each createDocument indiviudally but to run it concurrently

gotcha! aysnc it is. I think i saw a mention somwhere that its possible with graphQL but ive never touched it

You do not need to use graphql for that.