Building large csv with large amount of data - best solution

Hi there,

I dont have much experience when it comes to manage large of amount of data. I know and heard for example with pagination rather returning chunks of data at a time eg. 200 by 200.

I am nopw backing up my users into a csv and i would like to know if the same applies. should i apply the same process. so my file will be build into phases or should i have many csv’s???

Hope it makes sense.
Thanks for any help,

REgards,

Jerome