I added a csv file with ~2m rows, but I am experiencing some issues.
The sorting of rows for exemple is extremely slow, and the API will return a out of memory error if I try to query all values at once.
I would like to know about best practices when dealing with very big files, and what are the recomended hardware configurations (ex. RAM, HD, Processor) for these kinds of environments.
Thank-you for the attention.