What is the best solution to generating export csv data in performance term?
Laravel 5.7, MySQL, Maatwebsite/Laravel-Excel
generating for 10k-50k records take a long time and sometimes get a timeout error.
in 1 mouth the system will receive data 30k record.
current procedure: click the button -> query -> lopping for generating CSV data -> user download a file.
So, how can I improve this function, run in background, query/mysql improvement or something?