[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