I have never encountered a maximum number of rows I could export using CSV. Furthermore, the CSV export is built in batches, so your application should not run out of memory, even if you export a million rows. If you really need to know, you could use the Random Data Generator module from the AppStore, create a million records with fake data and try to export it to CSV.