jatiyanon
6 months ago
160
2
Laravel

What is the best solution to generating export csv data (Performance)

Posted 6 months ago by jatiyanon

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?

Please sign in or create an account to participate in this conversation.