Php display query results problem PHP MS SQL
I use PHP to connect to MSSQL and then use
$ SQL = "exec Report_a2013zhou_kpsfpout'', '2017-1-1 ', '2017-1-31 ','','','',''";
This statement executes the stored procedure and finds that the display results are incomplete. more than 1000 results are displayed after I directly execute the statement in the database analyzer, I found more than 6000 rows in the database, and the query on the webpage was very slow. after half a day, more than 5000 rows came out,
What is the reason? is there a limit on the number of rows and query time used in the stored procedure?
Reply to discussion (solution)
After waiting for a long time... it is clear that so many lines of browsers cannot be used at a time.
Batch display is not enough
I solved the problem by myself because my page exceeded the PHP. ini file or even 8 MB. now, I can change it to 20 to display it normally.