+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Issue with file download (/showthread.php?tid=45995)
Issue with file download - El Forum - 10-13-2011
[eluser]alberto24[/eluser]
Hi - I could use some help/advice. I have an app where customers can export files - sometimes the customer has say 3,000-10,000 records to download. Because the query to build the file has a couple of left joins, it takes a while to build the file - even if I just run the query directly in phpMySql, it takes a while.
Does anyone have any tips on how to speed it up or how to create a way to post a message like "your file is being created, currently on row 12 of 10,000"?
Also, is there a best practices way to create csv files from data? Is there some good code snippets I should be using?
Thank you