@Dhusanth Thangavadivel​ , In general how we configure the cluster is if we are planning to import data with 100 partitions. Then we need to make sure the cluster can spin up 100 threads.

It will also depend up on the DataBase, whether it will allow 100 connections at time.

What i observed is if any columns with huge text or blob data , then the write/read will be little bit slow.