good companions. I come here with a question about PHPExcel.
It happens that I use this library to create reports in Excel with a basic web application in PHP that performs a query in MySQL and it is the data that will go to this document. When I make small consultations (I speak of 150 or 1000 records) it has no problem, it throws it up in 1 minute without any problem ... but, with this query it brings me around 15 columns and with an amount of 57000 up to 100 thousand results .. it does not work for me and it ends up downloading the PHP application (the application is local on my computer).
I would like to know if said PHPExcel brings some limit of rows and columns since it is the explanation that, until now, I am contemplating. It should be noted that you already check the PHP code in case you are doing infinite loops, in MySQL check the query if you were doing something wrong and does not bring the records perfectly in less than 1 or 2 minutes and I have already used this line of code ONLY IN THE BIGGEST CONSULTATION THAT IS THE ONE THAT ROLLS MORE THAN 50MIL ROWS
ini_set('memory_limit', '4000M');
And, as you can see, I am even giving a very large limit of Memory. Also modify the php.ini file looking for the maximum execution time and increase it considerably as well.
I do not know what else may be affecting the PHPExcel, I do not know if it has a certain limit or maybe I probably have a little something in my code ... something I do not know, it could be ... but, as I said before, check it until you get tired. (In the same way if you want to add the code that I am using, I will not have any problem in editing here and adding the code)